Question

I would like to disable change tracking (CT)/change data capture (CDC) for a table in order to make a Data Definition Language (DDL) change (E.g., adding, modifying, deleting, or changing the data type of a column), then re-enable CT/CDC. How will the sync behave?

Environment

Connector: SQL Server

Answer

It is important to note that we are not able to replicate a table if CDC or CT is not enabled for the table. Any change due to the DDL operation will be synced when we start replicating the table. 

If we have already replicated the table, then you were to disable CT/CDC and make changes to the source table, and then re-enable CT/CDC, any changes made to the table during this period would be lost.

On the next sync update, our code will detect that the change tracking snapshot/version is invalid and automatically re-sync the table accordingly. If you are seeing a discrepancy, manually re-syncing the table will ensure data integrity.