topic Re: MS-CDC in Qlik Replicate

MS-CDC

ugoaku — Mon, 04 Dec 2023 11:19:55 GMT

Hello everyone good day and hope your weekend was eventful? I would like to ask a quick question?

I currently have MS replication enabled on an SQL database connected to Qlik for replication. The SQL database admin has suggested that they want to enable MS-CDC on the database to see how they can monitor activities. What will you advise under this situation? Because I am not sure that MS-CDC and MS Replication can coexist at the same time?
Or would enabling change data capture for specific tables be ideal though MS-Replication is enabled?

Thanks

Re: MS-CDC

john_wang — Mon, 04 Dec 2023 13:34:05 GMT

Hello @ugoaku ,

Welcome to Qlik Community forum and thanks for reaching out here!

IN short, MS-CDC and MS Replication can coexist at the same time, the detailed comparison can be found at MS_REPLICATION vs MS-CDC.

Hope this helps.

Regards,

John.

Re: MS-CDC

ugoaku — Tue, 05 Dec 2023 11:51:11 GMT

Thanks John for the feedback. Some tests have been done as in trying to generate a local replication transaction in an sql db and the target table was updated successfully.

Cheers.

Re: MS-CDC

ugoaku — Tue, 05 Dec 2023 12:04:16 GMT

Hi John

I am not clear on this line. Can you shed more light?

Re: MS-CDC

pedrobergo — Tue, 05 Dec 2023 12:49:59 GMT

Hi @ugoaku

Both methods reads TLOG information and execute sp_repldone to marks replicated records, but it can be owned only by one of the methods, then you need to avoid concurrency setting up skipMscdcJobFitnessCheck .

Get more details at https://community.qlik.com/t5/Official-Support-Articles/Qlik-Replicate-task-message-Failed-in-MS-CDC-fitness-check/ta-p/2045735

[],

Pedro

Re: MS-CDC

ugoaku — Tue, 05 Dec 2023 13:16:51 GMT

Thanks @pedrobergo . Much appreciated.