SQL Server Replication — Adding new articles to existing publishcation

  1. Add one or more articles through one of the following methods:

  2. After adding an article to a publication, you must create a new snapshot for the publication (and all partitions if it is a merge publication with parameterized filters). The Distribution Agent or Merge Agent then copies the schema and data for the new article to the Subscriber (it does not reinitialize the entire publication).
  3. After the snapshot is created, synchronize the subscription to copy the schema and data for the new article.

Leave a Reply

Your email address will not be published. Required fields are marked *