I have done some schema change (Add column for table) in merge replication for an article, is it applied for subscriber?

  • I have done some schema change (Add column for table) in merge replication for an article, is it applied for subscriber?

  • Only if the replicate ddl option is enabled in the publication.

    If it is not, you'll need to:

    a) reinitialise the subscriber

    b) drop the column from the publisher and add it using sp_repladdcolumn

    c) Do a lot of "under the hood" work by adding the column to the article, manually altering subscriber table..... etc

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

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