locked
adding column to merge article RRS feed

  • 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

     

    Monday, January 31, 2011 11:28 PM

Answers

  • 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

    • Marked as answer by kashif412 Wednesday, February 2, 2011 1:51 AM
    Wednesday, February 2, 2011 1:51 AM

All replies

  • 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
    Tuesday, February 1, 2011 10:15 AM
  • 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...

    Tuesday, February 1, 2011 11:44 AM
  • 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

    • Marked as answer by kashif412 Wednesday, February 2, 2011 1:51 AM
    Wednesday, February 2, 2011 1:51 AM