How to query between databases in SQL Azure Database Server

Question

I have an SQL Azure Database Server with three databases - A,B and C. In Database.A I have a Stored Procedure that needs to retrieve data from Database.B. How to query between the Databases?

Normally, I would reference the database like SELECT * FROM [Database.B].[dbo].[MyTable]but this does not appear to be allowed in SQL Azure.

Msg 40515, Level 15, State 1, Line 16 Reference to database and/or server name in 'Database.B.dbo.MyTable' is not supported in this version of SQL Server.

Is there a way to do this on the database end?

Answer 1

SQL Azure supports cross database queries: https://azure.microsoft.com/en-us/blog/querying-remote-databases-in-azure-sql-db/

Hope this helps!!

To know more about Azure, enroll today with our Azure certification course.

Thanks!!