Skip to main content

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.

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

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!