In Connect CDC v5.8, you can use the Change Data Capture (CDC) method to capture change data only for MS SQL Server 2012 or higher for Enterprise or Developer editions and for MS SQL Server 2016 SP1 Standard Edition or higher. For details refer to Microsoft SQL Server 2016 Service Pack 1 (SP1).
Note:
- For newly created MS SQL Server 2012 or higher models, the default replication method is CDC.
- For upgraded models the default replication method is trigger-based. However, you can use either the trigger-based or CDC methods to capture change data for MS SQL Server 2012 or higher.