Post reply

Change in Publication articles in Relication

  • January 28, 2010 at 3:18 am

    #215129

    We have transactional replication model. Now the thing is that 20 or 30 tables of publisher’s have changed. So to make it replicated, I am having two options;-

    (1) drop these articles from replication and create a new publication

    (2) rebuild the publication entirely

    What’s ur suggession? Should I go for option 1 or option 2?

  • January 29, 2010 at 5:34 am

    #1110647

    Schema changes to the tables are automatically replicated in transaction replication of SQL Server 2005 version. There is no need to recreate or rebuild the publication.

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

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