Post reply

Adding a column in a table for a replicated database

  • March 11, 2009 at 12:30 pm

    #206869

    Hi Guys:

    I have to add a column in a table for a database, but this database is being replicated, T-replication in here,

    My concern is will there be any problems if i add the column in the table, Does it affect Replication?

    what is the best way to add/make changes to a replicated database without breaking replication.

    Thanks

  • March 11, 2009 at 1:33 pm

    #957835

    sp_repladdcolumn in SQL 2000

    In Sql 2005 as per BOL.

    Adding a column to a replicated table article should be done by executing data definition language (DDL) commands against the published table. Replication automatically replicates these DDL commands as long as DDL replication has been enabled.

    You will get loads of Info in Books online regarding this. Make sure you test adding a column in a test environment before you do it in Production.

    -Roy

  • March 11, 2009 at 1:48 pm

    #957848

    In SQL 2005 ALTER TABLE ... ADD .. will propagate the DDL IF the publication was enabled to do it.

    Note the default is ON ( so you may be lucky 🙂 )


    * Noel

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

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