May 11, 2006 at 6:22 am
I have merge replication going on. but now i want to remove one table from replicating. how do i do it without effecting much the subricbers i have 10 subcribers for that one publications. Do i have re-create the replication again & run the snap shot again. is there any way to drop the table article from replicating to all the subcribers. please help me
May 11, 2006 at 8:55 am
I haven't used merge, but with trans repl, I do this:
Script out the "drop publication" commands
Paste into QA, and find just the portion that applies to the specific table. sp_drop_article or something like that.
Run just that command ... presto ... all done.
I often set up a mini-replication test environment, and then try things in there first before doing it in production.
May 13, 2006 at 12:44 am
The steps for this are
1. Ensure the databases are in sync
2. Delete the subscritpion
3. Recreate the subcription excluding the table you don't need
4. Now setup the publication, no need to transfer the data again, since the database is in sync.
5. Need to ensure no users logged during this process.
Hope this helps
rangark
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply