This documentation is for an older version of HVR.
Are the Existing CDC Tables and Articles Dropped in SQL Server During HVR Initialize?
Question
Are the existing CDC tables and articles dropped in SQL Server during HVR Initialize?
Environment
HVR 5
Answer
Yes, if you select the Drop Objects and Supplemental Logging options for the HVR Initialize, the existing CDC tables for the tables in HVR replication are dropped on the source database. This means that the other processes which are using these CDC tables will not see them anymore.
The articles are dropped only for the tables that are replicated by HVR.
The options shown in the following image will drop the CDC/Articles for the district and orders tables:
The options shown in the following image will drop the CDC/Articles for all the tables except new_order and orders:
