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?

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

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, privacy policy and cookie policy

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