Post reply

Adding Columns

  • July 11, 2006 at 6:04 am

    #97401

    Hi,

    I have a 3 database scenario.

    Database A is the Merge Publication

    Database B is the Merge Subscriber and a Transactional Rep Publisher

    Database C is the Transactional Subscriber.

    I need to add a column to a single article that is part of this scheme.

    A couple of questions:

    1 Can this be done without dropping any replication?

    2 What is the best order to add the column?

    Many thanks...Graeme

  • July 12, 2006 at 12:02 pm

    #648780

    You can add columns using sp_repladdcolumn, without dropping the replication. check out BOL for more info on syntax.

    Theoretically if you add the column on A, it would be propagated to B and since B is a publisher it would again be propagated automatically to C. So I belive you just need to add the column in A and watch if it gets all the way to C.

    ******************
    Dinakar Nethi
    Life is short. Enjoy it.
    ******************

  • July 12, 2006 at 1:47 pm

    #648811

    Correct you may want to look for

    sp_repldropcolumn

    and

    sp_addmergearticle

    You may need to have SP3 instaled.

     

    Pedro R. Lopez
    http://madurosfritos.blogspot.com/[/url]

  • July 13, 2006 at 1:18 am

    #648876

    Hey..thanks

    I've been looking at those procedures.

    Seems straightforward..but you never know.

    Thanks again

    Graeme

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply