topic Re: Temporarily disable Replication on a table in Qlik Replicate

Temporarily disable Replication on a table

billmcevoy — Wed, 26 Jun 2024 14:47:11 GMT

I am replicating data from SQL Server Database A to database B.

I need to rename a column in A.dbo.Table1 but I am getting this error:

Cannot rename the table because it is published for replication.

How can I disable QLIK Replication on that table while I make the change? I will be doing a full table load afterwards.

Re: Temporarily disable Replication on a table

DesmondWOO — Wed, 26 Jun 2024 16:21:19 GMT

Hi @billmcevoy ,

Thank you for reaching out to the Qlik Community. Please check if following the procedure helps:

Open Microsoft SQL Server Management Studio
Expand Replication and then Local Publication
Right click on your publication and select "Properties"
In the left pane of "Publication Properties", click "Articles"
In the right pane, uncheck the desired table.

Regards,
Desmond

Re: Temporarily disable Replication on a table

PGN — Wed, 26 Jun 2024 17:25:30 GMT

In order to remove it from replication, you're going to have to stop the running task(s) that contain the table to perform @DesmondWOO instructions. Otherwise, Qlik may pick up the table and mark it again before you're able to make the change in SQL.

Re: Temporarily disable Replication on a table

SushilKumar — Thu, 27 Jun 2024 05:10:00 GMT

Hello @billmcevoy

I would suggest removing the table from the participating task.

1. Reason QR will still scan the transaction logs as this table still part of replication .

2. if you add table later let say post 20 day. you need to do the full load as well.

Regards,

Sushil Kumar

As and when you want to add the table back to