MS-CDC Source: CDC remains enabled on SQL Server tables after Qlik Replicate task deletion

[Raffaele1]

Hi Qlik Community,

I am working with Qlik Replicate using Microsoft SQL Server (MS-CDC) as source endpoint and I noticed the following behavior that I would like to clarify.

When a Qlik Replicate task is created:

• CDC is automatically enabled on all captured tables in SQL Server

When a Qlik Replicate task is deleted:

•  CDC remains enabled on all tables that were part of the task 

When a Qlik Replicate task is deleted, I would expect Qlik Replicate automatically disables CDC on all tables that were part of the deleted task.

Is this the expected behavior of Qlik Replicate with MS-CDC source or should this be considered a bug and reported to Qlik Support?
Thanks.

[DesmondWOO · Accepted solution]

Hi @Raffaele1 ,

This is expected behavior and not a bug. Disabling CDC immediately drops the corresponding change table (_CT). Because other tasks or third-party tools might be sharing that change table, automatically disabling it could cause unintended data loss or break other processes.

Regards,
Desmond