Adding a table to a merge replication environment

• Daveee

  SSCommitted

  Points: 1580

  More actions

  September 21, 2006 at 5:10 am

  #91788

  Hi All,

  I was wondering if someone could advise me the best way to create a new table into a merge replication enviroment.

  I have 3 databases in this replication A- Publisher, B- Subscriber1, C- Subsciber2. The replication is continuous merge replication.

  I'd like to add a new table into the replication but I'm sure of the best way. Can someone tell me if this is the correct way to do it?

  1. Create a new table in the publisher database

  2. Use sp_addmergearticle to add the article to replication

  3. Use sp_refreshsubscriptions to push this out to subscribers

  I'd like to be able to do this without dropping my subscriptions if possible or without having to push a new snapshot out.

  Any help would be much appreciated.

  cheers,

  Dave

• rangark

  Right there with Babe

  Points: 738

  More actions

  September 23, 2006 at 12:02 am

  #662067

  I had responded on the same question when raised by another forum member.

  We have been using the following method which we found simple and reliable

  1. Create the table at subscriber and publisher database

  2. Add the rowguid column as well and create the index for the rowguid column

  3. Now add this newly created table part of article. Now you all set for the replication process.

  For adding a column to a table which is already published, you can use sp_repladdcolumn procedure

  rangark