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

Nilesh Patel 111 Reputation points
2021-10-11T10:19:15.003+00:00

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.139398-microsoftteams-image-2.png

Azure Database Migration service
Azure Migrate
Azure Migrate
A central hub of Azure cloud migration services and tools to discover, assess, and migrate workloads to the cloud.
718 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
495 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Oury Ba-MSFT 16,471 Reputation points Microsoft Employee
    2021-10-11T19:42:16.57+00:00

    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.

    139595-image.png

    Please let us know if you need additional Clarification

    Regards,
    Oury

  2. YufeiShao-msft 7,056 Reputation points
    2021-10-12T08:54:58.037+00:00

    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