This is actually really easy to set up and that what this blog post is about! The diagram below represents a query being issued against tables that exist in separate Azure SQL Database instances that contain different schemas.ģ. An elastic query can be executed across any two Azure SQL Database instances. Vertical queries (in preview): A vertical elastic query is a query that is executed across databases that contain different schemas and different data sets. The diagram below represents a horizontal elastic query.Ģ. An elastic query can be executed across many different databases that share the exact same schema but contain different data. You can read more about horizontal partitioning in Azure SQL Database here. This technique is commonly referred to as “sharding”. The data is partitioned across the many different databases and the (horizontal) queries issued are routed to the correct database based on a shard map. Horizontal queries (in preview): Horizontal elastic queries are queries that are executed across a set of databases featuring the same schema. Just keep in mind that the Elastic Query feature is currently in preview so there are some limitations to be aware of.ġ. There’s actually a few different types of cross database queries that you can run. But thanks to a new feature called “ Elastic Query”, we can issue cross database queries. Most people I talk to still think that cross-database queries in Azure SQL DB aren’t possible.
![adventureworkslt database diagrams adventureworkslt database diagrams](https://www.roelvanlisdonk.nl/wp-content/uploads/2011/08/image.png)
![adventureworkslt database diagrams adventureworkslt database diagrams](https://www.erdconcepts.com/gallery/adventureworks.jpg)
So rather than answering those questions repeatedly I figured I should blog my response up so from here on out I can just forward the link to this blog on to my customers and others interested.
#ADVENTUREWORKSLT DATABASE DIAGRAMS HOW TO#
A question that I answer what seems like all the time is how to run cross-database queries against Azure SQL Database.