Non-Oracle DB is illustrated with SQL Server as an example:
My train of thought
A:oracle DB production B:oracle DB Intermediate machine C:sqlserver db destination
a-> b->c Note: B on both the rep process and ext process, at this time, C also need to establish a rep process for B.
A->b can complete the online initialization synchronization (EXPDP based on the SCN number)
After the initialization of A->b, stop the rep process of B, at this time the B library is a static database, at this time B->c synchronization (using ETL Tools or SQL Server DTS, etc.)
When the initialization of the B->C is completed, the rep on the B is turned on, the rep on C is turned on, and the Ogg process on the three DB a-> b->c is in the working situation. When the rep lag on B is zeroed and the ext lag on B is zeroed, and when the rep lag on C is zeroed, the ext lag on a is zero and the DP on a is stopped. and record the EXT read checkpoint on a at this point, and record the DP read checkpoint on a at this point.
On a, the new transfer process from A to C is Dpatoc, and the DPATOC read checkpoint is modified. Create a new repfroma on C to apply the trail file that Dpatoc sent over.
Oracle Goldengate initialization data synchronization from Oracle DB to non-Oracle DB
