topic Re: Difference between ms-replication and ms-cdc in Sql server as the source in Qlik Replicate

Difference between ms-replication and ms-cdc in Sql server as the source

davinci_rajesh — Sun, 18 Dec 2022 12:55:26 GMT

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

Re: Difference between ms-replication and ms-cdc in Sql server as the source

Shai_E — Sun, 18 Dec 2022 14:56:17 GMT

Hello,

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.

Qlik Replicate: MS_REPLICATION vs MS-CDC - Qlik Community - 1939350

Hope This Helps

Re: Difference between ms-replication and ms-cdc in Sql server as the source

SwathiPulagam — Tue, 20 Dec 2022 07:53:50 GMT

Hi @davinci_rajesh ,

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:

https://help.qlik.com/en-US/replicate/May2022/Content/Replicate/Main/MicrosoftSQLServer-MSCDC/MicrosoftSQLServer-MSCDC-limitations.htm

https://help.qlik.com/en-US/replicate/May2022/Content/Global_Common/Content/SharedReplicateHDD/SQLServer-Source/limitations_source_SQLServerDB.htm

Thanks,

Swathi

Thanks,

Swathi