GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DDL Replication for existing Schema from Oracle to SQL Server

Gururaj0-OracleJul 14 2020 — edited Jul 15 2020

Hi Team,

There is an Oracle 12C Source Database with required Schema and Tables along with Data. On the Target end we have a fresh Sql Server Install. Question is, thru GG can we bring in the existing Schema/tables from Source(Oracle) to Sql Server(Target) ? Only after that, we can perform Initial Load followed by CDC.

I m guessing we cannot do this via GoldenGate but need to rely on SQL Server mechanism https://docs.microsoft.com/en-us/sql/ssma/oracle/migrating-oracle-databases-to-sql-server-oracletosql?view=sql-server-ve… ?

I also had a weird thought of creating a dummy Schema on the Source and doing an export/import inside Oracle while GG DDL replication enabled ?

Please let me know you thoughts & comments.

Regards

Gururaj

This post has been answered by Sreesha Nair-Oracle on Jul 14 2020

Jump to Answer

Added on Jul 14 2020

#goldengate

2 comments

494 views