合 【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.
Background
Previously, only Classic Capture was possible with SQL Server databases. With the Oracle GoldenGate 12c (12.3.0.1) 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
sysadmin
rights for this connection. You can alter the permissions todbowner
at a later time, if you want to use the same account for the Extract and are not allowed to have Extract running withsysadmin
.Unzip the
ggs_Windows_x64_MSSQL_64bit_CDC.zip
file to a new Oracle GoldenGate installation directory.Create a
GLOBALS
file in the base Oracle GoldenGate installation directory, and set theGGSCHEMA
parameter 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本人提供Oracle(OCP、OCM)、MySQL(OCP)、PostgreSQL(PGCA、PGCE、PGCM)等数据库的培训和考证业务,私聊QQ646634621或微信db_bao,谢谢!