1

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?

1

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.

  • 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 Sep 24 '18 at 18:40
  • Allow me to share with you the following documentation: docs.microsoft.com/en-us/azure/sql-database/… – Alberto Morillo Sep 24 '18 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 Sep 24 '18 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 Sep 24 '18 at 18:55

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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