Locked Add artilce in replication

  • Sunday, November 13, 2011 6:28 PM
     
     

    How to add article or table in publication?

    How to snapshot the only one particular article?

All Replies

  • Monday, November 14, 2011 6:21 AM
     
     Proposed Answer
    You can always add one article via the normal Replication UI. And at least with Transactional Replication (which I use most) the snapshot will be incremental then...
    • Proposed As Answer by Goden Yao[MSFT] Friday, November 18, 2011 10:43 PM
    •  
  • Tuesday, December 27, 2011 4:21 AM
     
     

    This can be done via the Publication Properties dialog or using T-SQL.  It involves adding the article to the publication, generating a new snapshot for the publication, and synchronizing the subscription(s) to apply the schema and data for the newly added article.  It does not reinitialize the entire publication.  After generating a new snapshot the distribution agent will copy the schema and data for the newly added article to the Subscriber(s).

    Have a look at Adding Articles to and Dropping Articles from Existing Publications for more information.