asked
how can i add new column in table which is already used by Snap shot Replication
Hi I am using Version:SQL 2005 Replication Type: Snap shot Replication I want to add a new column int not null in the existing table who have already in snapshot replication. Normally i do disable the articles and add the column and enable the articles. My Question: If I add the column in publication Is there any possibilites for re-initialize the subscriptions or fails?
@askmlx121 What does this mean? > If I add the column in publication Is there any possibilites for re-initialize the subscriptions or fails As you may already know that in case of snapshot replication, a new copy of the schema is sent to the Subscriber each time synchronization occurs. Therefore, all schema changes to previously published objects are automatically propagated with each synchronization. As far as you are following all the rules/guidelines provided in BOL, it should not fail at the subscriber. But you never know, so best would be test and see. BTW, here is the BOL link you should read prior to this exercise. [Considerations for Schema Changes][1] [1]:
http://msdn.microsoft.com/en-us/library/ms151870%28SQL.90%29.aspx
ok i understood usman. My thought would be Replication would fail or not if i altered the column. i saw that link more helpful.
welcome to our site:
www.topgoodssala.com we are a leading company in dealing with cheap brand sneakers(nike shoes,jordan shoes,air max, kicks jordan,nike shox,adidas,acics shoes, af1,bape,nike dunks,iceream,puma,timberland,etc),bags,jeans(red monkey,Levis,etc),T-shirts (lacosate,DG,prada,etc),hats,sun glasses,etc.We can provide all kind of series sneakers and others in my website and keep updating our stock with new colors and styles. Free shipment. Hope to cooperate with you and look forward to your early reply!
welcome to our site:
www.topgoodsell.com we are a leading company in dealing with cheap brand sneakers(nike shoes,jordan shoes,air max, kicks jordan,nike shox,adidas,acics shoes, af1,bape,nike dunks,iceream,puma,timberland,etc),bags,jeans(red monkey,Levis,etc),T-shirts (lacosate,DG,prada,etc),hats,sun glasses,etc.We can provide all kind of series sneakers and others in my website and keep updating our stock with new colors and styles. Free shipment.
welcome to our site:
www.topgoodsell.com we are a leading company in dealing with cheap brand sneakers(nike shoes,jordan shoes,air max, kicks jordan,nike shox,adidas,acics shoes, af1,bape,nike dunks,iceream,puma,timberland,etc),bags,jeans(red monkey,Levis,etc),T-shirts (lacosate,DG,prada,etc),hats,sun glasses,etc.We can provide all kind of series sneakers and others in my website and keep updating our stock with new colors and styles. Free shipment.
14 People are following this question.
