Groups | Blog | Home
all groups > sql server replication > august 2004 >

sql server replication : merge replication


Hilary Cotter
8/31/2004 8:09:14 AM
Use Windows Synchronization Manager for this. You can have replication
schedule to run when the user logs on.

--
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html


[quoted text, click to view]

Vivek
8/31/2004 2:22:15 PM
Hi Everyone,

I have an application set to merge replicate the MSDE (on remote machies)
and SQL (on Server), once the user logs on or logs off the application.
What I want is to set the replication so that the database replicates even
if the user is not logged on to the application. At the moment the agents
are stopped and when user logs on or off the merge agents do the respective
job. I tried keeping the agents running but in this case when user logs on
or offs the error is generated since the forced replication tries to
overwrite the already running agent.

Can someone please help me sort the issue?

Thanks
Vivek

Tony P
9/4/2004 12:27:01 AM
Create cycle merge agents. Copy the authentication info into a new agent set
as merge paste it and set the time intervals then point ehm at each other.
Run 1 if fail or success point to Run 2 and Run 2 points to Run 1 if fail or
success. Uses 2% proc every so many minutes you specify and self heals.
When server is there within minutes it is automatically replicating.

[quoted text, click to view]
AddThis Social Bookmark Button