This post has been republished via RSS; it originally appeared at: Azure Database Support Blog articles.
Today, I worked on a service request that our customer asked about how to connect from Azure SQL Database to Azure SQL Managed Instance.
Well, the first thing that I did is to enable the Public Endpoint of Azure SQL Managed Instance. After it, I followed up these steps:
- Create a table in Azure SQL Managed Instance
- Connect to Azure SQL Database I execute the following command to create the External Data Source to Azure SQL Managed Instance:
- Finally, running a SELECT * FROM Table1 I was able to obtain the information from Azure SQL Managed Instance.
Also, during my test, I found the option to run DML command using sp_execute_remote, for example,
Enjoy!