To solve our hybrid data center problem, we will configure a linked server to enable the SQL Server Database Engine to execute commands against data sources outside of the local instance of SQL Server. For instance, Oracle has the idea of a Database Link to Many other database providers have similar concepts. Microsoft has had the concept of a linked server since Sometimes solutions to new problems lie in the answers to old ones.

I cannot help but think about asking Weird Al Yankovic to re-write Madonna's 1984 hit song Material Girl to fit our situation?Īs a database administrator, one might wonder: How can I easily transfer data back and forth between On Premises and Azure SQL databases? Solution In the future, we will be living in a hybrid world in which data resides not only on premise in our local data center, but in the cloud at a Microsoft installation. The hope is that more companies will migrate their data to

The main purpose of this version is to narrow the syntactical differences between the on premise and in-cloud database engines. Microsoft released the preview version of Azure SQL Database V12 in December of 2014. Free MSSQLTips Webinar: Azure SQL Database performanceĪre you using or thinking about using Azure SQL Database and curious about performance differences compared to on-premises SQL Server? Attend this webinar to learn how to monitor performance for Azure SQL Database.

Does apex sql work for azure sql