Friday, March 23, 2012

How to run replications with different order articles

Our customers requested to run different order of articles
when perfore replicaitons. EX we have a,b,c,...tables.
How can I set the SQL server to replicate table b and d
first, then do rest of tables?
Thanks in advance
The simplest way is to have 2 publications and synchronize one before the
other.
Rgds,
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