July 19, 2005 at 2:04 am
How to remove an artice (table) from replication ?
thanks n regards,
Skv
subban
July 19, 2005 at 9:57 am
You'd should just be able to "un-click" a table to remove it from replication, but you can't.
What I do is:
1) Right click on the publication that you want to remove the table from.
2) Generate DELETE script.
3) Paste into Query Analyzer
4) Find and run the sp_dropsubscription and sp_droparticle commands for the table you want to run.
5) All done.
This technique, in conjunction with the CREATE script can be used if the schema of a replicated table needs to be changed.
You generate & SAVE both the DELETE & CREATE scripts. Remove it from replication, change the table, then add it back in with the relevant portion of the create script.
July 19, 2005 at 11:27 pm
ok, thankz.
Do i have to do anything at subscriber side ?
pls help
skv
subban
July 20, 2005 at 3:41 am
Hi Subban!
Some days after I implemented my replication, i needed to remove some tables of the publcation.
IS this your case?
I use Enterprise Manager and I had to delete my publication and create one new, because after publication is created we can't remove a table (article).
But be carefully, because you get an error if you don't delete this articles in the server subscriber!!
I hope this helps
Xau, Claudia
Cláudia Rego
www.footballbesttips.com
July 20, 2005 at 12:17 pm
No, I'm pretty sure you can leave the subscriber as is. I just did a test and everything worked fine. I removed 2 tables from a publication, deleted them from the subscriber, then let the jobs run, and the remaining table got updated at the subscriber with no problem.
You might want to manually delete the table(s) from the subscriber if it's no longer needed.
Claudia, try my suggestion next time, I think you'll find it's easier
July 21, 2005 at 7:29 am
You CAN do it from EM, you just have to remove the all subscriptions first, like the script does. I've done this a few times before, also added tables. But after dropping the table you need to re-add the subscription, and rebuild the snapshot.
Whichever way you do it, it leaves the subscriber's tables there. You can delete them if you like.
Dylan
Dylan Peters
SQL Server DBA
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply