March 15, 2012 at 3:38 pm
I have huge table which is getting replicated. I need to drop a column on the publisher side but I want to avoid the reinitialize the subscription option which is taking a long time. Is there any other way we can keep the replication running without generating a new snapshot.
March 16, 2012 at 5:08 am
Can't you just use the Alter table command and the dropped column will be dropped from the subscriber auotmatically. As replication now supports schema changes.
HTH
Graeme
March 16, 2012 at 7:17 am
Graeme100 (3/16/2012)
Can't you just use the Alter table command and the dropped column will be dropped from the subscriber auotmatically. As replication now supports schema changes.HTH
Graeme
That column was a part of article which I don't want to replicate to other servers now.
I can't drop a column on a table on publisher, I just don't want it to replicate.
March 16, 2012 at 7:38 am
deep_kkumar (3/16/2012)
Graeme100 (3/16/2012)
Can't you just use the Alter table command and the dropped column will be dropped from the subscriber auotmatically. As replication now supports schema changes.HTH
Graeme
That column was a part of article which I don't want to replicate to other servers now.
I can't drop a column on a table on publisher, I just don't want it to replicate.
I am not sure if it works without re-initialization, therefore you need to test it on some test server prior to do it on production.
1. Go to publication properties.
2. Select the article & expand it.
3. Uncheck the column that you want to avoid from replication.
March 16, 2012 at 8:44 am
I am not sure if it works without re-initialization, therefore you need to test it on some test server prior to do it on production.
1. Go to publication properties.
2. Select the article & expand it.
3. Uncheck the column that you want to avoid from replication.
It works, but it asks us to reinitialize the subscription with option generate a new snapshot which I don't want to do. I know there are commands sp_repldropcolumn. I tried them but its deleting the column from the main table(publisher side).
March 16, 2012 at 9:57 am
By removing a column from replication itself you are fundamentally changing the replication article. What has to happen is that a new article will need to be created, individual columns added to that article and then an article view will need to be created to cover just the columns that you want to replicate. That's a lot of work and will invalidate your existing unfiltered article.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply