all groups > sql server replication > november 2004 >
You're in the

sql server replication

group:

Manually transfer of merge data



Manually transfer of merge data or_dromi NO[at]SPAM walla.co.il
11/27/2004 11:02:57 PM
sql server replication: I need to replicate data between two servers through modem. The
problem is that the modem always disconnect in the middle of the
process.
This is not the initial replication. There were some success until the
last days, and there are data changes in both publisher and subscriber
that need to be merged.
Is it possible to transfer the merge data manually?

Re: Manually transfer of merge data Paul Ibison
11/28/2004 9:00:18 PM
You can't do this manually. You could change the merge agent properties to
optimize for an unreliable link - eg reduce the '...GenerationsPerBatch'
counters, and force it to restart after a network failure (3rd step -> 1st
step).
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

AddThis Social Bookmark Button