Azure Database Link to another Azure database

azureazure-sql-databasedatabase-linkdblinklinked-server

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!

Best Answer

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.