Servers Connections

dUrosdUros Posts: 21 Bronze 1
edited June 27, 2015 9:05AM in SQL Data Compare 11
Hi everyone

I would like to make a VB.Net application, using SDK with which i would compare and synchronize data from different SQL servers on different locations.
Synchronization would work over internet.
I'm interested in what kind of link between SQL servers you would recommend for security and stability (remote servers, linked servers, ... over VPN or not)?

Uros

Comments

  • Anu DAnu D Posts: 876 Silver 3
    Thanks for your post Uros!

    I would recommend you to go through this article and if you are able to connect to your SQL Server via SSMS the you should be fine with regards to SQL Compare/Data Compare/SDK.

    As per the article above this line felt like a key: "Although an Internet connection is less secure than a Microsoft ISA Server connection, using a firewall or an encrypted connection, as described below, helps keep sensitive data secure."

    Hope this helps.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
  • dUrosdUros Posts: 21 Bronze 1
    Thanks for your reply, I think this article will help for now. :D

    Uros
Sign In or Register to comment.