Tools to assess SQL Server instance running on a Azure VM to move to Azure SQL Managed Instance

Question

Hello,

Are there any tools to assess or to check the compatibility of the SQL Server databases running on a Azure windows VM to migrate to Azure MI? Regards,

Jay

Answer 1

@Jeevan Thank you for reaching out.

Use Azure Migrate to get Azure SQL deployment recommendations, target sizing, and monthly estimates.

Determine whether SQL Managed Instance is compatible with the database requirements of your application. SQL Managed Instance is designed to provide easy lift and shift migration for most existing applications that use SQL Server. However, you may sometimes require features or capabilities that aren't yet supported and the cost of implementing a workaround is too high.

The Azure SQL migration extension for Azure Data Studio provides a seamless wizard based experience to assess, get Azure recommendations and migrate your SQL Server databases on-premises to SQL Server on Azure Virtual Machines. Besides, highlighting any migration blockers or warnings, the extension also includes an option for Azure recommendations to collect your databases' performance data to recommend a right-sized Azure SQL Managed Instance to meet the performance needs of your workload (with the least price).

You can read more here for step by steps https://learn.microsoft.com/en-us/azure/azure-sql/migration-guides/managed-instance/sql-server-to-managed-instance-guide?view=azuresql

Create an Azure SQL assessment

Regards,

Oury