# Using Microsoft SQL Server (MS-CDC) as a source

This section describes how to set up Microsoft SQL Server (MS-CDC) as a source endpoint in a replication task. When replicating data from Microsoft SQL Server using 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 noteThis endpoint can also be used to replicate from an Amazon RDS for SQL Server source.

In this section:

* [Prerequisites](https://help.qlik.com/en-US/replicate/November2025/Content/Replicate/Main/MicrosoftSQLServer-MSCDC/MicrosoftSQLServer-MSCDC-prerequisites.htm)
* [Limitations and considerations](https://help.qlik.com/en-US/replicate/November2025/Content/Replicate/Main/MicrosoftSQLServer-MSCDC/MicrosoftSQLServer-MSCDC-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/Replicate/Main/MicrosoftSQLServer-MSCDC/MicrosoftSQLServer-MSCDC-data-types.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/Replicate/Main/MicrosoftSQLServer-MSCDC/MicrosoftSQLServer-MSCDC-general.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)