Groups | Blog | Home
all groups > sql server replication > october 2003 >

sql server replication : replication over dial-up networking


Ray D
10/30/2003 12:08:21 AM
It's simple. In the job that starts synchronization add
first step "rasdial connect <name of connection>" and last
step "rasdial disconnect".
Good luck!

[quoted text, click to view]
Chewang Dorji
10/30/2003 9:25:09 AM
Sir,

I would request somebody to help me 'HOW TO SCHEDULE DATABASE REPLICATION TO
AUTOMATICALLY DIAL THE MODEM AND SYNCHRONIZE AUTOMATICALLY at a scheduled
period of time'

I have a merge replication being configured and it works upon manually
connecting and manually synchronizing. I would be grateful if some one
could help me configure automatic dialing and automatic synchronizing.

Thanking you.

With regards,
Chewang Dorji

brian
10/30/2003 11:39:52 AM
Chewang,

From the subscribers computer click on Start > Programs >
Accesories > Synchronize. The synchronizer will enable
you specify time, dial up settings, etc.

To set up the synchronizer click on SETUP then on the
scheduled tab and then ADD. Name you scheduled
synchroniztion, choose your dial-up properties and what
publications you want to subscribe to and that should be
it. Make sure that you choose a dial-up connection
instead of the default (which is LAN Connection). You
will have to create a new saved dial in connection before
performing these steps though.

Brian


[quoted text, click to view]
Ray D
11/3/2003 4:06:37 AM
Ok. Let's step by step.

First you need to check manually that you subscription is
working ok.

Then create new dial-up connection.

Find your subscription.
Choose properties.
Then select Synchronization tab.
Click Agent Properties.
Choose Steps tab.
Add new step (with type Operating System command).
Type the following command - rasdial <connection name>.
At the Advanced tab - choose On success action - Goto next
step. This will be start step - connecting.

Edit Run Agent step - at the Advanced tab choose - On
success action - Goto next step, On failure action - goto
next step.

Add new step - this will be disconnection step. Choose
Operating System command and then type - rasdial
disconnect.

Then go to the Schedules tab, and make schedule you need.
Remember checking Enabled check-box.

Try to synchronize.

Good Luck!

[quoted text, click to view]
Chewang Dorji
11/3/2003 9:42:09 AM
Sir,
Thank you for the response. I would be grateful if you will help me ones
again of how to apply this configuration as I am a beginner and I am unable
to set it up.
Regards,
Chewang Dorji


[quoted text, click to view]

Chewang Dorji
11/3/2003 9:46:48 AM
Sir,
I thank you for your response. I will be grateful to you if could let me
know in detailed configurations as I am a begineer and I am unable to set it
up properly. Whatever I have done, it is not working.
with regards,
Chewang Dorji


[quoted text, click to view]

AddThis Social Bookmark Button