Updates to SQL Server Database Not Being Captured
Issue
Updates made to the SQL Server source are not being captured.
Description
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
Workaround
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.