Skip to main content

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

This section describes how to set up Microsoft Azure SQL (MS-CDC) as a source endpoint in a replication task.

When replicating data from Microsoft Azure SQL Managed Instance or Microsoft Azure SQL Database (using Microsoft Azure SQL (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 noteReplication from a geo-replica database is also supported. For more information about geo-replication, see https://learn.microsoft.com/en-us/azure/azure-sql/database/active-geo-replication-configure-portal?view=azuresql&tabs=portal

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!