I have few confusion for SQL migration from OnPrem to Azure in between DMA/DMS/ Data studio & Azure Migrate

Anonymous
2024-01-14T08:24:18.5566667+00:00

I have the below queries

  1. If Azure Migrate Readiness Report Recommend Onprem DB into Azure SQL Managed Instance & at onprem location, DMA was set up. In that case, is it required to set up Data Studio also at the on-prem location, as DMA does not support Managed Instance?
  2. If Azure Data Studio has set up an OnPrem location for SQL migration. Are we still required to Create an Azure Migrate Project & perform the Discovery, Assessment & Readiness Report? Can we ignore the Azure Migrate Project? Is Azure Data Studio enough for everything (Discovery, Assessment, Readiness Report & Migration)?
  3. The DMS is located at 2 places, inside Azure Migrate & a separate resource as Database Migration Service. Do both carry the same feature? Or ONLY "Azure Database Migration Service" exist as a separate resource supposed to be used?
  4. If I am using ONLY the separate resource as Database Migration Service, is still there a need to Create an Azure Migrate Project for Discovery, Assessment & Readiness Report Recommendation for SQL?
  5. In the Azure Migrate Project, the DB that has Discovered, Assessment & display under Readiness Report Recommendations, will that auto-display within Assessment tools=> Azure Migrate: Database Assessment?
  6. Is this Migration also a DR solution or works ONLY ONE-WAY? means ONLY Failover from On-Prem to Azure or support Failback also?
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
Azure Data Studio
Azure Data Studio
A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
98 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Nats 0 Reputation points
    2024-01-14T13:06:37.1333333+00:00

    Dear Herminder

    Good Day

    I am not very expert in Migration. But recently i have implemented On premise SQL Server (2019) to Azure SQL Database (PaaS).

    High level steps

    1. Download DMA tool
    2. Create the project and select assessment -> Gives how compatibility and any features depreciated
    3. Select Migration - provide source and destination details and select ONLY schema migrate
    4. Azure Portal --> Database Migration Service --> create project --> provide source and destination details --> migrate data

    Please feel free to reach out to me for more insights

    https://www.linkedin.com/in/santosh-v-1396b841/

  2. ShaktiSingh-MSFT 13,436 Reputation points Microsoft Employee
    2024-01-16T09:41:44.89+00:00

    Hi herminder bedi •, Welcome to Microsoft Q&A forum.

    As I understand, you want to perform migration of SQL server from On-Premises to Azure.

    Perform Migration to Azure SQL Managed instance using DMS as per below documents:

    Offline: https://learn.microsoft.com/en-us/azure/dms/tutorial-sql-server-to-managed-instance

    Online: https://learn.microsoft.com/en-us/azure/dms/tutorial-sql-server-managed-instance-online

    For Azure Data Studio ,refer https://learn.microsoft.com/en-us/azure/dms/migration-using-azure-data-studio?tabs=azure-sql-mi

    For Azure Migrate part, I would recommend you to raise a separate question with the tag so that Migrate team can help you with the solution.

    Hope this helps. Let us know if further queries.

    Thanks

    0 comments