2

Can a single application connect to two different databases each of which is in different Instances. One instance has on-premise deployment, the other one is Azure SQL(not SQL in Azure VM). So basically is it possible for an application to access data from both Instances?

1
  • If the answer will differ for each one then both.
    – igelr
    Oct 20, 2018 at 17:10

1 Answer 1

5

Yes, you can use so many connections you need.

For instance, if you're programming for .Net framework simply instantiate two or more SqlConnection class and set up the ConnectionString property according the DB you are trying to access.

You can find some examples about ConnectionString's here.

And MS Docs about Azure ConnectionString's here.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.