Home
%3CLINGO-SUB%20id%3D%22lingo-sub-368922%22%20slang%3D%22en-US%22%3ELesson%20Learned%20%2327%3A%20We%20would%20like%20to%20access%20tables%20from%20a%20database%20to%20another%20database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-368922%22%20slang%3D%22en-US%22%3E%0A%20%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CSTRONG%3EFirst%20published%20on%20MSDN%20on%20Jul%2029%2C%202017%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%20It%20is%20very%20frequently%2C%20that%20our%20customers%20ask%20about%20how%20to%20access%20tables%20from%20a%20database%20to%20another%20database.%20In%20Azure%20SQL%20Database%20there%20is%20not%20possible%20to%20access%20tables%20from%20another%20database%20in%20the%20same%20connection%20directly%2C%20for%20example%2C%20using%20database.dbo.table.%20We%20have%20a%20solution%20called%20Cross%20Database%20Queries%20in%20Azure%20SQL%20Database%20%3CSTRONG%3E%20-%20%3C%2FSTRONG%3E%20%3CA%20href%3D%22https%3A%2F%2Fazure.microsoft.com%2Fes-es%2Fblog%2Fquerying-remote-databases-in-azure-sql-db%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20https%3A%2F%2Fazure.microsoft.com%2Fes-es%2Fblog%2Fquerying-remote-databases-in-azure-sql-db%2F%20%3C%2FA%3E%20%3CSTRONG%3E%20%3C%2FSTRONG%3E%20that%20you%20will%20be%20able%20to.%20You%20just%20only%20need%20to%20create%20an%20EXTERNAL%20DATA%20SOURCE%20and%20mapping%20the%20tables%20with%20another%20database.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20You%20could%20find%20more%20information%20here%3A%20%3CBR%20%2F%3E%3CUL%3E%3CBR%20%2F%3E%3CLI%3E%3CBR%20%2F%3E%3CUL%3E%3CBR%20%2F%3E%3CLI%3E%3CBR%20%2F%3E%3CUL%3E%3CBR%20%2F%3E%3CLI%3EStep-by-step%20tutorial%3A%20%3CA%20href%3D%22https%3A%2F%2Fazure.microsoft.com%2Fen-us%2Fdocumentation%2Farticles%2Fsql-database-elastic-query-getting-started-vertical%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20https%3A%2F%2Fazure.microsoft.com%2Fen-us%2Fdocumentation%2Farticles%2Fsql-database-elastic-query-getting-started-vertical%2F%3C%2FA%3E%3C%2FLI%3E%3CBR%20%2F%3E%3CLI%3EOverview%20documentation%3A%20%3CA%20href%3D%22https%3A%2F%2Fazure.microsoft.com%2Fen-us%2Fdocumentation%2Farticles%2Fsql-database-elastic-query-vertical-partitioning%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20https%3A%2F%2Fazure.microsoft.com%2Fen-us%2Fdocumentation%2Farticles%2Fsql-database-elastic-query-vertical-partitioning%2F%3C%2FA%3E%3C%2FLI%3E%3CBR%20%2F%3E%3C%2FUL%3E%3CBR%20%2F%3E%3C%2FLI%3E%3CBR%20%2F%3E%3C%2FUL%3E%3CBR%20%2F%3E%3C%2FLI%3E%3CBR%20%2F%3E%3C%2FUL%3E%3CBR%20%2F%3E%20Enjoy!%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-368922%22%20slang%3D%22en-US%22%3EFirst%20published%20on%20MSDN%20on%20Jul%2029%2C%202017%20It%20is%20very%20frequently%2C%20that%20our%20customers%20ask%20about%20how%20to%20access%20tables%20from%20a%20database%20to%20another%20database.%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-368922%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Eaccess%20tables%20from%20a%20database%20to%20another%20database%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Ecross%20query%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eexternal%20table%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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:

Enjoy!