Using Microsoft SQL Server (MS-CDC) as a source

This section describes how to set up Microsoft SQL Server (MS-CDC) as a source endpoint in a replication task. When replicating data from Microsoft SQL Server using MS-CDC, changes are captured from Microsoft Change Tables as opposed to the SQL Server transaction log. Eliminating the need to rely on the transaction log minimizes the risk of data loss resulting from online transaction log retention time and backup transaction log inaccessibility.

This endpoint can also be used to replicate from an Amazon RDS for SQL Server source.

In this section:

Prerequisites
Limitations and considerations
Required permissions
Supported compression methods
Supported data types
Homogeneous replication
Setting general connection properties
Setting advanced connection properties
Removing Replicate artifacts from the database

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here