Temporarily disable Replication on a table

[billmcevoy]

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.

[DesmondWOO · Accepted solution]

Hi @billmcevoy ,

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

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

Regards,
Desmond

[PGN]

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.

[SushilKumar]

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