March 19, 2003 at 12:29 am
Hi All
I am changing the column design (increasing the varchar size ) of the table which is on replication. Can any1 tell me how to go about doing this. I have thos table in one of the publisher and there are 3 subscribers for this table at different servers.
Please can someone tell me how to go about doing this.
March 19, 2003 at 6:46 am
to change a column for a published article (table) you must drop the publication, change the table and then recreate and syncronize the publication.
If your publication is too big, to avoid generating the snapshot again, you can create the publication with sync_method ='none', but you must be carefull not to loose any transaction in the meantime, but also you can re create the snapshot once you have finishing changing the table and creating the publication
March 19, 2003 at 7:35 am
Easiest way is to drop the publication, make the change, then re-snapshot. You can shortcut some by stopping the logreader, making sure all transactions have been distributed, then removing the article for the table from the publication, altering it, then adding the article back. Then you start the logreader. It works, just be prepared to snapshot if something goes wrong.
Andy
March 19, 2003 at 10:21 am
quote:
Easiest way is to drop the publication, make the change, then re-snapshot. You can shortcut some by stopping the logreader, making sure all transactions have been distributed, then removing the article for the table from the publication, altering it, then adding the article back. Then you start the logreader. It works, just be prepared to snapshot if something goes wrong.Andy
http://www.sqlservercentral.com/columnists/awarren/
Andy do i need also to change the procedures at the subscription ,does dropping the subscription and changing the procedure will not do and then agian push the subscription.
otherwise it is a tediosu job to do, if this comes too often, and since i am new in tghis companya nd project , dont know y the replication consideration was not done properly. Why doesnt SQL Server gives the flexibility of changing the publocation properties any time u want..
March 19, 2003 at 12:33 pm
Sorry, left that out, you need to change the procs on the subscriber. SQL2K is better than SQL7, at least you can easily add/drop cols. Perhaps in the next version it will support changes as well.
Andy
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply