【OGG】Using the Oracle GoldenGate for SQL Server CDC Capture Replication

0    471    1


👉 本文共约2434个字,系统预计阅读时间或需10分钟。


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 ( release, the CDC Capture replication is introduced.

What Do You Need?

Before starting this tutorial:

【OGG】Using the Oracle GoldenGate for SQL Server CDC Capture Replication

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

  1. 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 to dbowner at a later time, if you want to use the same account for the Extract and are not allowed to have Extract running with sysadmin.

  2. Unzip the ggs_Windows_x64_MSSQL_64bit_CDC.zip file to a new Oracle GoldenGate installation directory.

  3. Create a GLOBALS file in the base Oracle GoldenGate installation directory, and set the GGSCHEMA 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 -

    . Do not to use the dbo schema.

    【OGG】Using the Oracle GoldenGate for SQL Server CDC Capture Replication后续精彩内容已被小麦苗无情隐藏,请输入验证码解锁本站所有文章!


Avatar photo





  • 18509239930
  • 个人微信

  • DB宝
  • 个人邮箱
  • 点击加入QQ群
  • 个人微店

  • 回到顶部