Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone good day and hope your weekend was eventful? I would like to ask a quick question?
Thanks
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.
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.
Hi John
I am not clear on this line. Can you shed more light?
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...
[],
Pedro
Thanks @pedrobergo . Much appreciated.