November 13, 2014 at 7:21 am
I added one table on a database which is configured in transactional replication , I don't want to run the snapshot of the entire database , how to replicate the newly added table in subscriber ?
November 13, 2014 at 7:36 am
When you add a new table to a publication, the snapshot runs only for the newly added article (if your snapshot hasn't become obsolete, obviously).
-- Gianluca Sartori
December 3, 2014 at 2:34 pm
Go to the properties of the publication and add this new table in the article and SQl server automatically generate snapshot for this table . No need to re run the entire snapshot.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply