August 8, 2023 at 6:35 am
Hello there Community,
we are using a Azure SQL DB. Now we want to get Data from some AWS RDS SQL Servers. Normally we would implement them per linked Servers, because we need the ability to get ad hoc data in queries.
But there are no linked Servers with an Azure SQL DB, only with the managed instance. Is there a way of emulation the get the same ad-hoc-compatibility to get Data cross servers with only a query? In best case just by adressing another server in the four-part-identifier?
Maybe i am thinking in a too narrowed way and im not seeing obvious good or even better solutions.
Thank you very much 🙂
August 8, 2023 at 7:01 am
I think Azure SQL DB allows External Tables but am unsure if that will get you as far as AWS.
It might be better to do the queries directly from the application. eg Enity Framework allows joins from two, or more, contexts:
As I presume querying AWS from Azure will also incure data egress charges by AWS, you may also want to look at creating copies of the AWS tables in Azure. You might be able to get this near real time with Azure Data Factory. If you have a lot of concurrent users this might help with egress charges from AWS.
> we need the ability to get ad hoc data in queries
If these are for analysis, another approach would be to create a data warehouse.
ps This might be of interest:
https://www.mssqltips.com/sqlservertip/6445/azure-sql-cross-database-query/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply