Edit on GitHub
Updates to SQL Server Database Not Being Capturedlink
Issuelink
Updates made to the SQL Server source are not being captured.
Descriptionlink
When capturing from a SQL Server database, if Change Data Capture (CDC) is disabled on the database, the updates made to the tables are not captured.
You can check if CDC is enabled by running the following statement against the database:
sys.sp_cdc_help_change_data_capture
Workaroundlink
To resolve this issue, do the following:
Enable CDC for the database. This can be done by running HVR with supplemental logging and Scripts and Jobs option enabled.
Perform a full refresh to capture the missed updates.
NOTE: Capture rewind does not work in this case because CDC was disabled and the changes have not been logged in the change tables.