Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2002

    Unanswered: Replicate from ACcess to SQL Server on Dialup

    Our application requires daily transfer of data from the remote locations (in MS Access) to the central server (SQL Server). The appllication is developed on VB.

    The remote locations would be inserting the data (to the tune of 3 MB/day). Data in the central server will also get modified. Transfer has to take care of to-and-fro flow of data.

    I understand that writing log files is the most common approach. DTS also could be useful. Any suggestion from someone who have come across a similar scenario is welcome.

    Thanks in advance.

  2. #2
    Join Date
    May 2003

    Probably the most robust way would be export the data from access to a text file, then copy across the dialup to the sql box, then import to sql via DTS.

    You probably could link direct over the dialup via dialup netowrking, it just depends on how robust the process has to be.

    We used to have to get data via a dial up radio link to an outback mining site in a monsoon weather area in australia once - lightning used to drop the link regularly so we perfected copying stuff efficiently .....

    Text files may be clunky, but it removes so many issues with reliability.


    Last edited by sqlguy7777; 11-02-03 at 20:12.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts