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.