This documentation is for an older version of HVR.
Updates to SQL Server Database Not Being Captured
Issue
Updates made to the SQL Server source are not being captured.
Environment
HVR 5
Resolution
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.
Cause
This issue occurs when you capture from a SQL Server database where Change Data Capture (CDC) is disabled.
You can check if CDC is enabled by running the following statement against the database:
sys.sp_cdc_help_change_data_capture