Lesson Learned #27: We would like to access tables from a database to another database
Published Mar 13 2019 06:45 PM 603 Views
First published on MSDN on Jul 29, 2017
It is very frequently, that our customers ask about how to access tables from a database to another database. In Azure SQL Database there is not possible to access tables from another database in the same connection directly, for example, using database.dbo.table. We have a solution called Cross Database Queries in Azure SQL Database - https://azure.microsoft.com/es-es/blog/querying-remote-databases-in-azure-sql-db/ that you will be able to. You just only need to create an EXTERNAL DATA SOURCE and mapping the tables with another database.

You could find more information here:

Version history
Last update:
‎Mar 13 2019 06:45 PM
Updated by: