Difference between ms-replication and ms-cdc in Sql server as the source
I have been wondering about the differences ms-replication and ms-cdc in the source. Lately I have been trying out replication and cdc in the sql server to replicate my data. But I am not fully aware when to use them. Can you please help me understand the use case? #qlikreplicate
I found the following community Article, which talks about this subject: the difference between the replication techniques, when to use each, explanations in regard to each technique.
In simple words, MS Replication will hold transactions in Tlog, and Replicate can read those transactions from Tlog before they got truncated\archieved. To use MS replicate your tables must have PK.
Whereas MS CDC will maintain the transactions in change tables and Replicate can read data from these change tables. Using MS CDC you can Replicate tables even without PK.
You can check the User guide for more details on both solutions:
I found the following community Article, which talks about this subject: the difference between the replication techniques, when to use each, explanations in regard to each technique.
In simple words, MS Replication will hold transactions in Tlog, and Replicate can read those transactions from Tlog before they got truncated\archieved. To use MS replicate your tables must have PK.
Whereas MS CDC will maintain the transactions in change tables and Replicate can read data from these change tables. Using MS CDC you can Replicate tables even without PK.
You can check the User guide for more details on both solutions:
