Will I be able to use Elastic Queries from Paas DB and SQL VM DB. Since these two databases were at onprem used to connect with Linked server. Now two databases are migrated Azure SQL VM and another one is Azure SQL Single DB.

Elastic database queries you will have it available on Azure SQL Database as a way to perform cross-database queries with Azure SQL Databases only, you cannot get databases managed by SQL Server instances involve in elastic queries. On SQL Server VM (Azure and on-premises) you can perform cross database queries as usual, and you can get Azure SQL databases involved by using linked servers to Azure SQL database. You will be able to perform cross database queries on the Azure SQL VM that involve the other database migrated to Azure SQL by creating linked server to Azure SQL. However, you won't be able to perform elastic queries on Azure SQL with the databases you will have on the Azure SQL VM.

Elastic Database queries

Accepted answer

Alberto Morillo 34,356 Reputation points MVP

2022-06-15T12:14:18.513+00:00

Elastic database queries you will have it available on Azure SQL Database as a way to perform cross-database queries with Azure SQL Databases only, you cannot get databases managed by SQL Server instances involve in elastic queries. On SQL Server VM (Azure and on-premises) you can perform cross database queries as usual, and you can get Azure SQL databases involved by using linked servers to Azure SQL database.

You will be able to perform cross database queries on the Azure SQL VM that involve the other database migrated to Azure SQL by creating linked server to Azure SQL. However, you won't be able to perform elastic queries on Azure SQL with the databases you will have on the Azure SQL VM.
Please sign in to rate this answer.
Prakash M, Bhanu 211 Reputation points

2022-06-15T12:19:38.947+00:00

Thanks for the information.

Is there any documentation from Microsoft article with above information?

Alberto Morillo 34,356 Reputation points MVP

2022-06-15T12:43:33.293+00:00

On this documentation you will find this excerpt "Elastic query works with Azure SQL Database only". Here you will find how to create a linked server on a SQL VM that connects with an Azure SQL database.

Prakash M, Bhanu 211 Reputation points

2022-06-15T12:45:34.147+00:00

Unable to open that document

Alberto Morillo 34,356 Reputation points MVP

2022-06-15T13:13:24.733+00:00

It s not a document. It is a URL or Web address.

Alberto Morillo 34,356 Reputation points MVP

2022-06-15T13:14:36.007+00:00

It is now fixed. Sorry.

Prakash M, Bhanu 211 Reputation points

2022-06-15T13:29:12.173+00:00

Thanks a lot

Alberto Morillo 34,356 Reputation points MVP

2022-06-15T13:50:47.87+00:00

You are very welcome. Thank you for visiting Microsoft QA forums. Have a great day!
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Elastic Database queries

0 additional answers

Your answer