Remote target apply

If you are deploying the CDC Replication Engine for Microsoft SQL Server as a target, you have the option of installing the product on a system that is remote from the target database.

To allow CDC Replication to communicate with the target database, you must install Microsoft SQL Server connectivity tools on the server where you install CDC Replication.

You must install the Management Objects (SMO) package that corresponds to the version of the Microsoft SQL Server database which is being used for replication:

Microsoft SQL Server 2017

You must install Microsoft SQL Server Management Studio (SSMS) 17.x

Microsoft Azure SQL Database

You must install Microsoft SQL Server Management Studio (SSMS) 17.x.

Microsoft Azure SQL Database Managed Instance

You must install Microsoft SQL Server Management Studio (SSMS) 17.x.

Microsoft SQL Server 2016

You must install the SQL Server 2016 Management Objects (SMO)

Microsoft SQL Server 2014

You must install the SQL Server 2014 Management Objects (SMO)

Microsoft SQL Server 2012

You must install the SQL Server 2012 Management Objects (SMO)

The SMO package must be installed on the same server as the CDC Replication software.

For more information, see your Microsoft SQL Server documentation.