Streams and Advanced Replication

Replication provides copies of data to different servers, and it can be used to move data. While it isn’t a failover mechanism usually associated with high availability, it does help ensure that data is available and can provide a way to selectively pull out the important data.

SQL Server has replication to distribute transactions to a subscriber. You create the publisher, which can be various tables, and then you can make subscriptions to the publisher for replicating to another server. The SQL Server publisher, distributor, and subscriber fill the roles of capture, stage, and consume or apply. Some setup with a replication administration user and another database is required.

For replication, Oracle offers Oracle ...

Get Oracle Database Administration for Microsoft SQL Server DBAs now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.