July 9, 2003 at 10:11 am
Hi all,
I have 5 remote server locations and 1 main back office server. All have SQL 2K, I need help and first to know if it is possible to have a SQL replication over a dialup connection?
If at all possible, then the replications must happen at any time that any server dials up to the number on the modem connected to any other server. How
to accomplish this in the SQL?
Please help and thanks you in advance.
Cheers!
July 14, 2003 at 12:00 pm
This was removed by the editor as SPAM
July 14, 2003 at 1:17 pm
Replication will work as long as you have connectivity. If you know when you'll have a connection, you could schedule the job to run then. Otherwise you either have run every x minutes to try to connect, or run in manually. Probably could write something that would ping the remote server, if it went through, start the job if not already started. I don't know of a direct way to hook to the dialup connection being established. Some type of scripting maybe.
Andy
July 15, 2003 at 12:06 am
I once found this extended procedure which might be usefull for you. It's called xp_dialup or so and opens and closes a dial up connection if needed. I must admit I never used it in production but maybe it's worth a try.
For download see: http://www.databasejournal.com/scripts/article.php/1500881
Markus
[font="Verdana"]Markus Bohse[/font]
July 28, 2003 at 6:52 am
Dear Markus,
Thankx a lot for replying,
I followed but the link / file seems to no longer exist there.
So far nor clues any where!
Cheers
July 28, 2003 at 10:30 am
You could use transactional replication, or any type you decide.
Then create a batch command that executes the jobs of the distribution agent. You can use osql -Q"exec msdb.dbo.sp_start_job..." inside a batch file to fire the jobs.
You can use rasDial.exe to stablish a connection, and when the connection is made, you execute your batch file to start replication.
then you can creates scripts to control the status of the replication, and improve it a bit more.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply