SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Creating a Linked Server to an Azure SQL Database

Why would you create a Linked Server to an Azure SQL Database?

If you work in a hybrid environment with some databases stored on your on premises SQL Server instances and you also have deployed some databases to Azure SQL Database, maybe you have archived a bunch of data up to the cloud to free some space on your on premises servers but you still want to query that data.  You might want to query the azure SQL Server databases from your on-premises SQL Server instances for a whole bunch of other reasons too. Then you might want to create a Linked Server to your Azure SQL Database

In this short video David talks you through the process of creating a linked server to an Azure SQL databases

You can download the free ebook: Putting Your Head in the Cloud: An Introduction to Cloud Computing and Azure SQL Database

If you have any questions, please leave them in the comments


Leave a comment on the original post [www.gethynellis.com, opens in a new window]

Loading comments...