SQL
Server mirroring competes with Oracle Streams
In this article we see that Microsoft SQL Server 2005 has a new
“mirroring” features, very simulate to the Oracle 10g Streams
replication:
http://www.databasejournal.com/features/mssql/article.php/3440511
Maintaining
synchronized copies of a database on two separate servers allows
switching between them on an as needed basis, reversing roles of
partners participating in the mirroring session, (the former
principal becomes the mirror and vice versa). With database
mirroring, this process can be automated, which requires the
presence of another instance of SQL Server 2005
Of course, with MSSQL being a latecomer to the market, Oracle10g
Streams has a huge head-start, and we suspect that the Oracle 10g
Streams solution is far superior.
For details on Oracle 10g Streams, see Madhu Tumma’s $9.95 book
“Oracle Streams”
http://www.rampant-books.com/book_2004_2_streams.htm
|
