adding column to merge article

Question

ALL,

 I have merge replication configured on sql server 2008..i have one main publisher and 10 republishers....all 10 republihsers are having dynamic filters..

I have to add column on main publihser to existing article...i want this column to replicate to republishers and and end subscribers..without reinit republishers and end subscribers

I guess i should use alter table to add column and making sure replicate schema changes is enabled on main publihser and republihsers..Right?

Please give some reocmmendations..

TIA

 

Answer 1

Please check this link.

 

http://msdn.microsoft.com/en-us/library/ms152493.aspx

 

HTH

Vinay

---

Vinay Thakur http://rdbmsexperts.com/Blogs http://vinay-thakur.spaces.live.com/ http://twitter.com/ThakurVinay

Answer 2

Vinay link u sent was for adding articles ..to make schema changes here is link

http://msdn.microsoft.com/en-us/library/ms151870.aspx.

Reason i posted question is just want to make sure i am not doing anything wrong...

Answer 3

This is what i followed

  used alter table.. to add column and making sure replicate schema changes is enabled on main publihser and republihsers...then by default when merge agent runs it syncs with subscriber..u can see column in subscriber