question

askmlx121 avatar image
askmlx121 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?
replicationsnapshotarticles
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

askmlx121 avatar image askmlx121 commented ·
no one know this question answer.............???????????????
0 Likes 0 ·
Usman Butt avatar image
Usman Butt answered
@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
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

askmlx121 avatar image askmlx121 commented ·
ok i understood usman. My thought would be Replication would fail or not if i altered the column. i saw that link more helpful.
0 Likes 0 ·
topgoodsale avatar image
topgoodsale answered
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!
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

topgoodsale avatar image
topgoodsale answered
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.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

topgoodsale avatar image
topgoodsale answered
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.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.