Hello SSC,
My company is in the process of a migration from SQL 2012 to 2016. Our production environment is replicated. If CDC is enabled, what impact will it have? Will all of the CDC tables get replicated? Is it wise to have CDC on a replicated environment?
Thank you all in advance for your time.
The are no problems, only solutions. --John Lennon
October 9, 2019 at 12:10 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
October 9, 2019 at 7:49 am
Both CDC and Replication has their own unique purposes. CDC captures the Audit Log of the table and Replication ensures that all the Secondary instances are up to date with the Primary.
Basis my understanding, CDC tables should get replicated else the purpose of CDC would be defeated.
You can spend some time reading the below URL.
what type of replication do you have setup ?
if SQL Server replication then only the tables you select for replication will be replicated.
If SAN replication then all objects on the databases get replicated regardless of what they are.
Note that if using SQL Server replication it is not required to replicate the CDC tables unless you need them on the other server/database as part of your own processes.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply