Post reply

Updating data between two different SQL servers

  • May 23, 2003 at 7:37 am

    #59178

    Hi,

    We have an ecommerce site situated at our suppliers'side.

    The data is situated on our SQL server.

    We want to update his SQL server every 4 hrs.

    We registrated his SQL server at our side en made a DTS package. A drop and recreate tables. It took some time though and the site was down for 10 minutes.

    Then we've created a replication. But this doesn't seems to work.

    What is the best way to update his server with our data. The link is through the internet.

    Kind regards

    J

    JV


    JV

  • May 26, 2003 at 6:47 am

    #458495

    I would still use replication. I would use transactional replication and use it with internet. Check in BOL or ask here to know how to set up replication-

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply