Groups | Blog | Home
all groups > sql server replication > july 2006 >

sql server replication : Merge Replication


Samuel Shulman
7/12/2006 4:33:19 PM
Hi

I have to use Merge replication (as oppose to transaction) because we use
MSDE, in order to have similar functionality I want to make very frequent
updates

Is it possible/recommended to replicate every 10 minutes

Thank you,
Samuel Shulman

Paul Ibison
7/12/2006 4:47:25 PM
Samuel,
this largely depends on the acceptable latency. However there are advantages
in having a regular schedule like this though (as opposed to a continuous
schedule) - the metadata will be regularly removed and any connection
problems won't be terminal.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

AddThis Social Bookmark Button