Configuring the CDC Replication Engine for Microsoft SQL Server for Azure SQL Database

You can use the CDC Replication Engine for Microsoft SQL Server to replicate to a Microsoft Azure SQL Database target or a Microsoft Azure SQL Database Managed Instance target.

CDC Replication supports Azure SQL Database as a remote target only. The Azure SQL Database requires an encrypted JDBC connection. For details about the encryption settings, see Adding an instance of the CDC Replication Engine for Microsoft SQL Server.

The CDC Replication target can either be installed on premises or in an Azure VM. For optimum performance, the CDC Replication target should be installed on a VM in the same region as the Azure SQL Database.

When the source is on premises and the target is in an Azure VM, the network connection can be encrypted with TLS encryption or with a VPN. When using a VPN, specify the virtual network IP address rather than the public host name or IP address to connect from the CDC Replication source. After installing CDC Replication and configuring an instance, open the CDC Replication instance port on the VM Windows firewall.

Set up IP filtering in the Azure SQL Database to allow connections from the CDC Replication target system.