Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Schema Changes in Merge Replication

 
   Database Forums (Home) -> Replication RSS
Next:  Volunteer Scheduling  
Author Message
siva

External


Since: Jan 19, 2009
Posts: 9



(Msg. 1) Posted: Thu Jan 29, 2009 8:33 pm
Post subject: Schema Changes in Merge Replication
Archived from groups: microsoft>public>sqlserver>replication (more info?)

i am using merge push subscription.
i have to update/modify the schema in publication db.
So the changes in the publication db should be reflected in Subscriotion db.
i have more than 25 subscribers. How can i do the schema changes ?.
What are the things i have to do ?. I am little bit worried about data loss .

 >> Stay informed about: Schema Changes in Merge Replication 
Back to top
Login to vote
Paul Ibison

External


Since: Oct 03, 2008
Posts: 35



(Msg. 2) Posted: Fri Jan 30, 2009 7:29 am
Post subject: RE: Schema Changes in Merge Replication [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

It depends on the schema changes you are intending, but pretty much most
things are permitted and will replicate just fine. Check that your articles
are set to replicate ddl changes first and then make the changes one by one
(if possible) and sync up.
HTH,
Paul Ibison

 >> Stay informed about: Schema Changes in Merge Replication 
Back to top
Login to vote
Display posts from previous:   
   Database Forums (Home) -> Replication All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]