Problem Summary

Do the existing CDC tables and articles get dropped in Sql*Server when HVR initialization is done?

Environment

HVR 5

Description

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.

Answer

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.