2

Let me preface this what what I'd like to accomplish and see if this is inline with the expectation of using Azure SQL DB.

Currently I use a couple Virtual Machines in Azure that use a linked server to execute some stored procedures to hit a database outside of Azure (the external database is in AWS)

I'd like to move to use the Azure SQL Server to query an external database but I'm not seeing documentation around setting up an external data source that's just a SQL DB - only elastic within your own Azure network. Is this outside the scope of the product?

Improve this question

1 Answer 1

Reset to default
2

Currently Azure SQL Database only allows to query other Azure SQL Databases or Azure SQL Data Warehouse databases by using elastic queries. Linked servers are not supported on Azure SQL Database. Currently is not possible to query SQL Server instances or other RDBMS from Azure SQL Database.

The new PaaS product named Azure Managed Instance allows to create linked servers but for a limited number of targets. Supported targets: SQL Server and SQL Database. Not supported targets: files, Analysis Services, and other RDBMS. For more information, please read this blog.

Improve this answer
5
  • hey Alberto - Is there any documentation that explains the differences between Azure SQL Server and Azure Managed Instance? In my case it sounds like if I want to transition from the VM with SQL server on it I would need to use the Managed Instance.
    – Matt
    Commented Sep 24, 2018 at 18:40
  • Allow me to share with you the following documentation: learn.microsoft.com/en-us/azure/sql-database/…
    – Alberto Morillo
    Commented Sep 24, 2018 at 18:44
  • learn.microsoft.com/en-us/azure/sql-database/…
    – Alberto Morillo
    Commented Sep 24, 2018 at 18:44
  • I appreciate the time you have taken, have you used Azure Managed Instance to recommend using it over a hosted VM with SQL Server installed?
    – Matt
    Commented Sep 24, 2018 at 18:46
  • It is in Preview but it will go to GA soon. At this time is at half the price in terms of costs, you may want to take advantage of that. If you query the sys.dm_hadr_fabric_nodes DMV you will find 5 nodes on each instance (kind of a cluster). Business critical option has SSD in-memory OLTP.
    – Alberto Morillo
    Commented Sep 24, 2018 at 18:55

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.