SQL Azure doesn’t let you run queries between database instances. But if you’re migrating off on premise databases where you’ve been able to do that you probably don’t want to rewrite a bunch of code. Turns out there is a way around that using SQL Azure Elastic Query.

Links
Documentation - https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-query-overview