April 10, 2010 at 12:24 pm
Hi All,
We already have replication setup in our production server.
If we add new articel to the server
Do we need to generate entire snapshot of the publication then distributer?
Can we run snapshot for single article and run distributor?, If so How?
Can we have same table participate in Snapshot replication aswell transactional replication?
Note: Subscriber database is same for the both replications snap and tran.
Please do not ask me why you want this because our production server was like this and my client want like that 🙂
Thanks in Advance
Rajesh Kasturi
April 13, 2010 at 8:29 am
Yes, you need to generate a new snapshot if you add an article to a publication.
However, you could add a new publication (it doesn't matter if it's on the same database or not), add the article, and you don't have bother the other publications/subscriptions
Can we have table participate in Snapshot replication aswell transactional replication?
I am not sure, but don't. Remove it from the snapshot publication, and then add it to the transactional publication.
April 13, 2010 at 10:11 am
You can add an article to an existing publication.
Refer :
http://deepakrangarajan.blogspot.com/2009/01/sql-2005-transaction-replication-adding.html
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply