# 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

In this section:

* [Prerequisites](https://help.qlik.com/en-US/replicate/November2025/Content/Replicate/Main/MicrosoftAzureSQLMS-CDC/azremscdc-prereqs.htm)
* [Limitations and considerations](https://help.qlik.com/en-US/replicate/November2025/Content/Global_Common/Content/SharedReplicateHDD/Azure-MSCDC-Source/azremscdc-source-limitations.htm)
* [Required permissions](https://help.qlik.com/en-US/replicate/November2025/Content/Global_Common/Content/SharedReplicateHDD/Azure-MSCDC-Source/azremscdc-SQLServerDBSource-security.htm)
* [Supported compression methods](https://help.qlik.com/en-US/replicate/November2025/Content/Global_Common/Content/SharedReplicateHDD/Azure-MSCDC-Source/msmazuremi_supported_compression_methods_sql_server.htm)
* [Supported data types](https://help.qlik.com/en-US/replicate/November2025/Content/Global_Common/Content/SharedReplicateHDD/Azure-MSCDC-Source/msmazuremi_SQLServerDB_source_DataTypes.htm)
* [Homogeneous replication](https://help.qlik.com/en-US/replicate/November2025/Content/Global_Common/Content/SharedReplicateHDD/Azure-MSCDC-Source/msmazuremi_Homogeneous_Replication.htm)
* [Setting general connection properties](https://help.qlik.com/en-US/replicate/November2025/Content/Global_Common/Content/SharedReplicateHDD/Azure-MSCDC-Source/msmazuremi_SQLServerDB_DiaBox_source.htm)
* [Setting advanced connection properties](https://help.qlik.com/en-US/replicate/November2025/Content/Global_Common/Content/SharedReplicateHDD/Azure-MSCDC-Source/msmazuremi_SQLServer_advanced.htm)
* [Removing Replicate artifacts from the database](https://help.qlik.com/en-US/replicate/November2025/Content/Global_Common/Content/SharedReplicateHDD/Azure-MSCDC-Source/remove-artifacts.htm)