Another Replication Question - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Another Replication Question

Author

Topic

icw
Constraint Violating Yak Guru

378 Posts

Posted - 2006-03-21 : 06:44:02

Hi all,
I have been practising with replication and have set up a databse which is syncing succesfully continuously. I have 2 questions
1. If I want to change the schedule, do I just change the schedule on the merge agent job?
2. Ideally I would like sql server to automatically detect when the publication is available and to sync then. Because I will have the database on a laptop which will only connect to the domain once every day (at night) So I want to just get a vpn connection and it will automatically sync... do I NEED TO USE Windows Synchronization Manager to handle this?

thanks in advance

ICW

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2006-03-21 : 07:19:34

1. Yes.
2. I think you may have a few issues with this, but I guess it's worth a try..