Post reply

T-Repl

  • May 22, 2011 at 9:23 am

    #238558

    Hi Team,

    In transaction replication in Publication database i want add one column on one article how can i add col in the article.

    how can we update this new column in subscriber database through distribution same article please guide me..

    Thanks in advance...

    tx

  • May 22, 2011 at 11:03 pm

    #1328282

    With SQL 2005, you can get replication to do most of the work for you. To get this in place, the publication should be created with @replicate_ddl = 1. I don't think you can do this through the GUI. You will need to use sp_addpublication.

    I suggest that you script out the publication and confirm the setting before making any changes.

    Once the publication has been created with this option set, statements such as 'ALTER TABLE ... ADD COLUMN' will result in the equivalent change being done on each of the subscribers.

  • May 23, 2011 at 6:57 am

    #1328431

    sp_repladdcolumn is an alternative but this will be removed in Denali.

    sp_repladdcolumn offer useful parameters that ADD COLUMN does not. Such as the ability to add the column to a single publication.

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

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