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!
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.