Connector Improvement: Automated CDC Management and Targeted Resync for SQL Server BLR Connector
Which connector?: Binary log reader for SQL Server
Additional details:
- Automatically disable CDC when unchecking tables: When a table is deselected in the schema tab, CDC [Change Data Capture, the feature that tracks database updates] should turn off automatically on that table in SQL Server. Since Fivetran already enables CDC when a table is selected, adding this reverse behavior will keep our database transaction logs from growing unnecessarily large.
- Trigger targeted resync when CDC is disabled on selected tables: If a selected table has CDC turned off at the source database, Fivetran currently triggers a warning, stops syncing, and risks clearing out the destination table in live mode. Instead of just warning us, Fivetran should automatically trigger a single-table resync to re-enable CDC and reload the missing data. Fivetran already handles this when a table is dropped and recreated, so we would like to see that same behavior extended here.
Please sign in to leave a comment.
Comments
0 comments