Part VII Using Oracle GoldenGate for SQL Server

With Oracle GoldenGate for SQL Server supports capture and delivery of initial load and transactional data for supported SQL Server database versions.

Oracle GoldenGate for SQL Server supports the mapping, filtering, and transformation of source data, unless noted otherwise in this document, as well as replicating data derived from other source databases supported by Oracle GoldenGate, into SQL Server databases.

This part describes tasks for configuring and running Oracle GoldenGate for SQL Server.

Topics:

• Understanding What's Supported for SQL Server
  This chapter contains information on database and table features supported by Oracle GoldenGate for SQL Server.
• Preparing the System for Oracle GoldenGate
  This chapter contains steps to take so that the database with which Oracle GoldenGate interacts is correctly configured to support Oracle GoldenGate capture and delivery. Some steps apply only to a source system, some only to a target, and some to both.
• Preparing the Database for Oracle GoldenGate — CDC Capture
  Learn how to enable supplemental logging in the source database tables that are to be used for capture by the Extract for SQL Server and how to purge older CDC staging data.
• CDC Capture Method Operational Considerations
  This section provides information about the SQL Server CDC Capture options, features, and recommended settings.
• Requirements Summary for Capture and Delivery of Databases in an Always On Availability Group