Hi,
Is there a way one can tell when the Merge Replication between the
publisher and subscriber is done completely? Because, when replicating
large tables, it does take considerable amount of time, and I want to
somehow ensure that the replication is completed before disconnecting
the subscriber.
I appreciate any help in this regard!
Thanks!
Jane.
Jane,
if you're using the the activeX controls, they have a status event.
You could use the On Success action of the Run agent step of the merge job.
Alternatively you could check the latest record for this agent in
MSmerge_history (if you're not in continuous mode, you should get the
message 'No data needed to be merged.' at some time).
HTH,
Paul Ibison
Wednesday, March 21, 2012
Indicating the end of replication
Labels:
database,
indicating,
merge,
microsoft,
mysql,
oracle,
replicatinglarge,
replication,
server,
sql,
subscriber,
thepublisher
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment