Competition: What’s your favorite Redgate tool? Enter now.

Is it possible to synchronize data between local and remote

compviscompvis Posts: 13
Hi,

I have two SQL databases with the same type. One is on local computer, and other one is on remote computer (internet connection, not LAN connection).

I have a question: Is it possible to synchronize two databases if i use SQL Data Compare SDK ?

If can, how can i do it ?

Thank you so much !

Comments

  • Thanks for you post.

    As long as you can connect to them using SSMS (or QA/EM), then you can connect to them using our API.

    The connection string you use for SSMS can probably be used with our API.

    I'd try it out with SQL Compare UI first, just to make sure you can connect. Then use the same string in the 'register' method in the API.
    Chris
  • thanks, i will try it
Sign In or Register to comment.