Wednesday, March 21, 2012

Need Clarification - merge replication

Hi,
I need to add new tables to merge replication.
These are the steps I have followed,
1. Executed the table script both in Publisher & Subscriber
2. Add 'rowguid' column in that table (Publisher & Subscriber)
3. In publication properties-->Articles, included the new table and
snapshot was automatically started.
(a) Is it the correct way to add tables to merge replication or is there any
better way?
(b) Should I stop the merge agent during this process?
Please advise.
Thanks,
Soura.
Soura,
unless you're doing a nosync initialization, it is normal to add the
articles to the publication, run the snapshot agent then the merge agent. A
full snapshot is created, but only the new article will get propagated.
There's no need to deal with the guid column - it'll get created for you if
a guid (rowguid) isn't there.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

No comments:

Post a Comment