Do the existing CDC tables and articles get dropped in Sql*Server when HVR initialization is done?
This article describes a very important concern that can arise when same CDC tables are shared by HVR and processes other than HVR when replicating tables from SQL Server.
Yes. When HVR initialize is performed with options 'Drop Objects' and 'Supplemental Logging' 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 table(s) which is/are replicated by HVR.
The options shown in below image will drop the CDC/Articles for tables district, orders, testpallavi1 and testpallavi2
The options shown in the below image will drop the CDC/Articles for all the tables except new_order and orders.