Lesson Learned #27: We would like to access tables from a database to another database

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:

• 
  
  
  
  • 
    
    
    
    • Step-by-step tutorial: https://azure.microsoft.com/en-us/documentation/articles/sql-database-elastic-query-getting-started-vertical/
    
    
    • Overview documentation: https://azure.microsoft.com/en-us/documentation/articles/sql-database-elastic-query-vertical-partitioning/
    
    
    
    
  
  
  
  

Enjoy!