Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2006
    Posts
    2

    Lightbulb Unanswered: How send data to another remote SQL Server

    I want to post all the data in my company branch office in Lahore to the Head office in Peshawar. This will be done at the end of the day and the two SQL SERVERs synchronize data between both points over internet. what procedure should i use? and how the two computers will know the ip addresses of each other while connecting?

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245
    Quote Originally Posted by jollygood
    I want to post all the data in my company branch office in Lahore to the Head office in Peshawar. This will be done at the end of the day and the two SQL SERVERs synchronize data between both points over internet. what procedure should i use? and how the two computers will know the ip addresses of each other while connecting?
    Look at Merge Replication in SQL BOL.

    Regards,

    hmscott
    Have you hugged your backup today?

  3. #3
    Join Date
    Oct 2006
    Posts
    3
    Do you have a VPN connection between the 2 servers?

    Read this link : http://www.databasejournal.com/featu...le.php/1438231
    Last edited by rjohansson; 10-05-06 at 07:08.

  4. #4
    Join Date
    Oct 2006
    Posts
    2
    ya the two servers are in vpn

Posting Permissions

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