Skip to main content
GoldenGate

Comparison between DB Visit and Oracle GoldenGate

By November 1, 2014September 12th, 2016No Comments

Comparison Report between DB Visit and Oracle GoldenGate

 

SNO DBVISIT ORACLE GOLDENGATE
1 Supported on only Standard Edition and Standard Edition One (SE / SE 1). Supports All Editions like Enterprise Edition (EE), Standard Edition and Standard Edition One (SE / SE 1).
2 Before Starting the Replication, Synchronization of SCN can be done only using the EXPDP / IMPDP. Before starting the Replication, Synchronization between source and target can be done using EXPDP / IMPDP or GoldenGate In-Built feature called INITIAL LOAD.
3 Small Application Outage is required to obtain Single SCN. No Application Outage is required.
4 Once Migration is complete, reset the Sequences on the Target Table. No Reset of Sequences are required.
5 Need to Enable Supplemental Logging. Need to Enable Supplemental Logging.
6 Partitioning is Not Supported. Supports Partitioning.
7 Source should be always Oracle Database and Target can be any database. Egs: Oracle to Oracle, Oracle to SQL Server, Oracle to MySql etc., Source and Target can be any Database. Egs: Oracle to Oracle, SQL Server to Oracle, Oracle to MySql etc.,

Leave a Reply

© 2020 ORACLE-SCN. All Rights Reserved.