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.