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
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.

