I hava a scenario where I have an SQL Server set up as the publisher (merge)
and the subscribers are Laptops with MSDE which work mostly offline.
The subscribers are updated once they are online with the publisher.
My question is: How can the subscriber tell if the MSDN database has
finished the replication with the publisher?
You see some times the laptops are online just a few minutes and the
connection is slow. I need to make sure the subscribers are online just long
enough to complete the merge !
I appreciate any help I get can on this issue :-)
Regards
Peter
You could also hook into the sql server com object on the client. This will
allow you to start the sync manually if required. It also has the benifit of
haveing a callback so you can display a progress. If the server and client
stop talking to each other because of a time out period away from the
network this manual method will reinistialise the connection.
- Mike
"Peter F" <Peter F@.discussions.microsoft.com> wrote in message
news:BB950EB3-A351-4077-96AD-F5BBBDD7F7F0@.microsoft.com...
>I hava a scenario where I have an SQL Server set up as the publisher
>(merge)
> and the subscribers are Laptops with MSDE which work mostly offline.
> The subscribers are updated once they are online with the publisher.
> My question is: How can the subscriber tell if the MSDN database has
> finished the replication with the publisher?
> You see some times the laptops are online just a few minutes and the
> connection is slow. I need to make sure the subscribers are online just
> long
> enough to complete the merge !
> I appreciate any help I get can on this issue :-)
> Regards
> Peter
No comments:
Post a Comment