DMA and DMS From On-premise SQL Server to Azure SQL managed instance

Question

1.I can not use Migration part through DMA from SQL server to Azure managed Instance? Getting the message I can only use DMS for that(attaching the screenshot of the message).

Somewhere in Microsoft Learn I read that we can use DMA for migration from SQL server to Azure SQL managed instance.

Please clarify my doubt.

Answer 1

Hi @Nilesh Patel Thank you for posting your Question on Microsoft Q&A.

DMA is needed if you want to assess before migration with DMS. Alternatively, if you use the Azure SQL Migration extension in Azure Data Studio, you can run assessments and migrations in a single place. The Data Migration Assistant provides seamless assessments of SQL Server on-premises and upgrades to later versions of SQL Server or migrations to SQL Server on Azure VMs or Azure SQL Database. It also help you helps you upgrade to a modern data platform by detecting compatibility issues that can impact database functionality in your new version of SQL Server or Azure SQL Database.
Please see the Migration guide : SQL Server to Azure SQL Managed Instance.

Please let us know if you need additional Clarification

Regards,
Oury

Answer 2

Hi @Nilesh Patel ,

DMA only supports the migration of on-premises SQL Server instance to a modern SQL Server instance hosted on-premises or on an Azure virtual machine (VM) that is accessible from your on-premises network. The Azure VM can be accessed using VPN or other technologies.

to Azure SQL Managed Instance, you can see refer to this document:https://learn.microsoft.com/en-us/azure/azure-sql/migration-guides/managed-instance/sql-server-to-managed-instance-overview