How to fetch data from multiple data centres.

Question

I have my SQL databases spread across multiple data centres. Let me know the efficient way to fetch data from multiple data centres.

Answer 1

You can query multiple SQL databases at once. Things are a bit dependent on the set-up of your databases. If all are set-up identically, you can have a look at sharding. Otherwise elastic queries might be a solution for you. Things are explained in this documentation page: https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-scale-introduction?view=azuresql

Even though the description is focussing on elastic pools, this is NOT a requirement.