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 ...