Oracle GoldenGate for SQL Server allows users to capture changes made to a specific set of tables in one database and deliver those changes to corresponding tables in another database in near real time.
Replication can serve several purposes in database information management:
- Replication can provide a backup of specified table data in the event of problems with the primary database.
- If the site is dual active, and one system becomes unavailable, the remaining system can automatically take over database operations. The data on the systems will have been automatically synchronized via replication.
- When implemented between SQL Server and databases from other vendors, data can be migrated from one system to the other, making data accessible across the different environments.
The complete document can be found on the Oracle Support site under the document ID:1502204.1