Home / server / Questions / 123339
Accepted
Refracted Paladin
Asked: 2010-03-18 03:26:45 +0800 CST

Will this force a reinitialize in Merge Replication Topology?

  • 772

I need to add a couple of columns to a table that is a part of a replication set. It is not a constraint coulumn or a part of any article filters and it allows NULL. I have a pretty good idea that I can run this --> ALTER TABLE tblPlanDomain ADD ReportWageES VARCHAR (100) NULL

and NOT force all my clients to reinitialize but I was hoping for some reassurance. Can anyone verify this one way or the other for me?

Thanks,

Edit: Addtnl Info

This is what I am talking about --> http://msdn.microsoft.com/en-us/library/ms151870.aspx

It would seem, based on that, that the answer to my question is NO but I would still like a human confirmation.

sql-server sql-server-2005 replication merge-replication

2 Answers

  1. Best Answer

    nah the schema changes will be replicated. It won't force the subscription to re-initalize. The clients are all sql server 2005, right?

    You should probably check that replication schema changes are set to true for the publication.

    I also tested this in my lab environment on sql server 2005 to be sure. You should really set one up, instead of relying on other persons.

    • 1

  2. With MERGE replication, I believe this will force a reinitialization of the subscription. This is not the case for transactional or snapshot replication.

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

    • 0