February 21, 2007 at 7:06 am
Hi all
I'm pretty new to the concept of replication. So please bear with me if my question sounds really weird.
There is transaction replication set up for a database whose size is around 50 gigs. Now there were some changes in the structure of a table and i want these chnages to be replicated to the other server.
Now what will I have to do for this??
Will the whole replication happen again or is there a way that i can pass on the chnages in this table to the other server.
February 21, 2007 at 9:30 pm
If the changes (to tables that are already published) have already been made, it is too late. You will need to drop the article and then re-publish it.
If the changes are still pending, have a look at sp_repladdcolumn. This is the only way to add columns to a published table and actually get replication to notice.
If your requirement is to change the datatype of an existing published table, you will need to drop any articles containing that table, make the change and then re-publish.
Having said that, you may be able to avoid having to deliver a new snapshop for the table if you make sure that no updates are made to the table whilst you are making the change. You would apply the same change to both the publisher and the subscriber(s) and then when you create the subscription, you tell replication that the subscriber already has both schema and data.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply