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.

Replication 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

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