August 19, 2003 at 5:56 pm
Hi
Just wondering if there any way you can drop a table that's being replicated and recreate it?
August 20, 2003 at 1:33 pm
Yes, but only if you drop the publication and after altering your table, re create the publication again.
October 6, 2003 at 9:30 am
I did this with good results when I needed to change the length of a field in a replicated table.
-- Specifically: Drop a table from a publication so it can be modified, then add the table back in.
1) I just scripted out the CREATE Publication and the DROP publication commands to text files.
2) Ran just the portion of the DROP publication that had to do with TableA
3) Modified FieldA from 6 char to 8 char on publication & subscription databases.
4) Ran just the portion of the CREATE Publication dealing with TableA
5) Ran the snapshot job
6) Ran the pull subscription job
7) Checked the table in the subscription database & it has the same data as the source table.
Maybe there's a "gotcha" I missed, but it seemed to work fine.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply