Qlik Replicate: DDL Change Handling for MSSQL-CDC

[Michael_Litz]

Due to a limitation in MS-CDC source endpoint DDL changes on the source must be handled manually.

Table-level DDLs are not supported. When a table DDL is encountered, the DDL will be transferred to the target and the table will be suspended to allow the CT table to be manually aligned.

Resolution:

1. The following steps show how to handle a DDL change on a table.

   Alternate DDL Change Handling for MS-CDC endpoint task only. Do not need to do this for a standard MS SQL endpoint.

   1. Stop the Qlik Replicate task
   2. Disable ms-cdc for the table in the source database
   3. Modify the source table
   4. Modify the target table
   5. Start the task with metadata only run (Create missing tables and then stop). This will refresh the internal metadata without losing position.
   6. Enable ms-cdc for the table (if task is not set to do it automatically)
   7. Resume the task

Environment

Qlik Replicate  
SQL Server MS-CDC

Related Content:

Limitations and considerations
Qlik Replicate: The metadata for source table 'table name' is different than the corresponding MS-CD...