Question
Why does HVR's log-based data capture need SQL Server's Replication Components?
In the requirements for Microsoft SQL Server, it is mentioned that SQL Server Replication Components need to be installed. Why?
Environment
Local Data Processing
Answer
For the currently used methods for HVR (>v4.7) to read the SQL server log ("SQL" and "Direct"), SQL Server Replication Components are only required for supplemental logging management, not for the change capture itself.
Requirements are that
- SQL Server Standard Edition, versions below 2016 Service Pack One requires SQL Server Replication Option to be installed.
- SQL Server Standard Edition, Express, and 2005 editions the default value /SupplementalLogging set to ARTICLE_OR_CDCTAB (default)
- SQL Server Enterprise, Developer and 2008 Editions, Replication Components should not be required when only using CDC tables to enable supplemental logging. To use this feature simply define the Capture action with /SupplementalLogging option set to CDC_TAB. On Enterprise Edition versions we default to using CDC tables.