Showing posts with label replicaitons. Show all posts
Showing posts with label replicaitons. Show all posts

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)