question

AnirudThapliyal-9057 avatar image
0 Votes"
AnirudThapliyal-9057 asked VaibhavChaudhari answered

How can I query Azure sql db managed instance from Azure sql db?

We have Azure sql db and Azure sql managed instance (for db migrated from on-premise sql server).

I want to query tables of managed instance from Azure sql db through a stored procedure using joins.
Is this valid and possible scenario? How this can be achieved?


Thanks in advance!

azure-sql-database
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

VaibhavChaudhari avatar image
0 Votes"
VaibhavChaudhari answered

You can try using replication to replicate data from SQL MI to Azure SQL or schedule pulling required data to some staging tables in Azure SQL.

See similar thread - https://stackoverflow.com/questions/54174982/is-possible-to-connect-azure-sql-managed-instance-from-azure-sql-db


Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.