Microsoft KB Archive/241149

= HOW TO: Automate Replication over a Dial-Up Connection =

Article ID: 241149

Article Last Modified on 2/23/2004

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q241149



SUMMARY
This article describes the process for automatically initiating replication over a dial-up connection. The process involves using a scheduled job to establish the dial-up connection and then perform the synchronization. This procedure is described in more detail in the "More Information" section of this article.



MORE INFORMATION
To configure automatic replication over a dial-up connection, you must first install replication on your SQL Server as you normally would. You can use the Configure Publishing and Distribution Wizard to set up replication, and then use the Create Publication Wizard on the publishing server to create the publication. Next, use the Pull Subscription Wizard on the subscribing server to create the pull subscription. You should use a pull subscription rather than a push subscription because you want the subscribing server to initiate the subscription.

NOTE: When you set up replication, choose a transactional publication on the publisher and a pull subscription on the subscriber. This creates the Distribution Agent job on the subscriber and the Log Reader Agent job at the publisher.

After you install replication and create the publication and pull subscription, create a new multi-step scheduled job on the subscriber. This job should have the following steps:

After this multi-step scheduled job has been created, it should run at your predetermined schedule to perform the replication over the dial-up connection.

NOTE concerning WAITFOR: The values for the WAITFOR statement are examples only; you should replace them with appropriate values for your own situation.

NOTE concerning the Distribution Job: The Distribution Job should be scheduled to run "One Time". The Distribution Job completes after transferring the accumulated published transactions.