Part VII Using Oracle GoldenGate for SQL Server

With Oracle GoldenGate for SQL Server, you can perform initial loads and capture transactional data from supported SQL Server versions and replicate the data to a SQL Server database or other supported Oracle GoldenGate targets, such as an Oracle Database.

Oracle GoldenGate for SQL Server supports data filtering, mapping, and transformations unless noted otherwise in this documentation.

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.
• Requirements Summary for Capture and Delivery of Databases in an Always On Availability Group
  
• CDC Capture Method Operational Considerations
  This section provides information about the SQL Server CDC Capture options, features, and recommended settings.