How to Migrate Azure SQL Database to Azure SQL Managed Instance

The latest version of SQLPackage supports migration to Azure SQL Managed Instance (MI) from multiple SQL sources such as Azure SQL Database. Export: Following the below steps, you can export a SQL database using the SQLPackage command-line utility. If possible, use a workstation that has access to the Azure SQL Database and the MI to avoid having…

0

Lesson Learned #63: It is possible to create Linked Server in Azure SQL Managed Instance?

The answer is Yes!!! and to create it you only need to follow up the instructions provided in this URL   Unfortunately, nowadays, you only are able to use the SQL provider to connect to Azure SQL Database, SQL Server or Azure SQL Managed Instance. My lessons learned in this situation is you need to pay attention For Azure SQL Database: Please review…


Lesson Learned #61: Using Schemas in Azure SQL Managed Instance

Hello Team, This week I worked on a service request where our customer asked about the compatibility feature using schemas and partitioning, for this reason and thanks to near 100% compatibility of SQL Server we have the option to create schemas and split tables among different filegroups. I would like to share with you the…


Lesson Learned #60: Using Partition Option in Azure SQL Managed Instance

Hello, Time ago, we discussed in this post about partitioning option in Azure SQL Database. One of the main differences creating this partition in Azure SQL Database is all partition will use the same filegroup. In Azure SQL Managed Instance we could create different filegroups and files for each partition having a better performance having multiple…


Lesson Learned #55: Azure SQL Managed Instance – Backup failed for Server “servername”. Failed: 1117 -The request could not be performed because of an I/O device error

Hello, I found several service requests that our customers are trying to proceed with a backup of a Azure SQL Managed Instance to Azure Storage Account and they are facing an error, after reaching 40%: Backup failed for Server “servername”. Failed: 1117 (The request could not be performed because of an I/O device error). Working on this issue I found: I found that the size of the database is +/- 300 GB. The error message reported…