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