合 【OGG】Using the Oracle GoldenGate for SQL Server CDC Capture Replication
Before You Begin
This tutorial shows you how to use the CDC Capture replication, which utilizes the SQL Server Change Data Capture feature to read DML from the transaction log and load it into individual staging tables for each user table enabled with supplemental logging. The CDC Extract then reads the DML from the staging tables and reconstructs transactions then writes the data into trail files.
This tutorial takes approximately 15 minutes to complete.
Previously, only Classic Capture was possible with SQL Server databases. With the Oracle GoldenGate 12c (188.8.131.52) release, the CDC Capture replication is introduced.
What Do You Need?
Before starting this tutorial:
Using the following tasks, you create both a Uni-Directional and a Bi-Directional SQL Server to SQL Server Replication.
一、Setting Up the Uni-Directional CDC Extract
Create a system DSN to the source database and set the change the default database to option to the source database. Use a Windows or SQL Server login that has
sysadminrights for this connection. You can alter the permissions to
dbownerat a later time, if you want to use the same account for the Extract and are not allowed to have Extract running with
ggs_Windows_x64_MSSQL_64bit_CDC.zipfile to a new Oracle GoldenGate installation directory.
GLOBALSfile in the base Oracle GoldenGate installation directory, and set the
GGSCHEMAparameter to that of an existing or new schema in the source database. Oracle recommends that you create a specific schema for Oracle GoldenGate objects.
For example -1CREATE SCHEMA ggs
. Do not to use the dbo schema.1GGSCI> EDIT PARAMS ./GLOBALS