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

Jeevan 20 Reputation points
2024-03-08T18:41:33.1666667+00:00

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

Azure SQL Database
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
907 questions
0 comments No comments
{count} votes

Accepted answer
  1. Oury Ba-MSFT 16,076 Reputation points Microsoft Employee
    2024-03-08T19:21:00.32+00:00

    @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


0 additional answers

Sort by: Most helpful