In order to make your issue reports as actionable as possible, please provide the following information, depending on the issue type.

Feature request or enhancement

For feature requests or enhancements, provide this information, please:

Which use case/requirement will be addressed by the proposed feature?

Using the MS SQL Server Debezium source connector for data replication

Implementation ideas (optional)

Debezium does a great job of moving SQL events from the source to the topic. Unfortunately we have seen MS SQL server CDC issues cause source and target tables to become out of sync. There is no existing process to "re-sync" these tables. Yes, you can trigger an incremental snapshot or even delete and recreate the source connector to redo an initial snapshot but both processes fail to address extra records in the target table or missing deletes. The T-SQL MERGE statement can handle inserts, updates, and deletes so I think this can be used to create a "sync" process which ultimately puts the target table in perfect sync with the source. This feature would be vital for customers using this product for data replication.