0

How to query between two databases with the same server in SQL Database?

Currently we are aiming to link two azure databases that will update simultaneously.

Thanks!

0

Cross-database queries are not available in Azure SQL Database. You need to use Elastic Query to query across multiple Azure SQL Databases or move to a Managed Instance, which does support cross-database queries but obviously has a higher cost and other implications.

0

Linked servers are not available on Azure SQL Database, but reading your needs, you really need to get both databases updated at the same time. You may want to consider using Azure SQL Data Sync to get those databases updated/synchronized.

Here you will find a get started tutorial.

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.