SQL Database from Azure VM to Azure SQL Server : DB Size ( 300 GB DB)

Taswar Hussain 31 Reputation points
2023-02-01T16:37:19.5633333+00:00

I want migration SQL Database from Azure SQL VM to Azure SQL Server. My DB Size is 300GB. But I want a faster way how to migrate DB to Azure SQL Server. I want migration in only under 5 minutes. I don't want Downtime on my DB during migration.

Can you suggest to me the best way to do so?

Azure SQL Database

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Alberto Morillo 32,806 Reputation points MVP
    2023-02-01T20:37:04.43+00:00

    What you need is called an "online" migration and Azure Data Migration Service (DMS) is the tool/service you need. This tutorial of the old version should help you do all the steps needed.

    The new DMS uses Azure Data Studio and with the new version online migrations are supported only with Azure SQL Managed instance as target and not for Azure SQL Database as mentioned on this documentation.

    I hope the old version still gives you the option for online migrations. If the old version does not allow you online migrations anymore, then what you are looking for is not currently possible.

    0 comments
  2. Oury Ba-MSFT 16,076 Reputation points Microsoft Employee
    2023-02-02T06:07:29.7166667+00:00

    Tasawar Hussain In addition to what @Alberto Morillo mentioned above. If you are using Azure SQL as target you find supported scenarios and the latest updates in the main page Migrate databases by using the Azure SQL Migration extension for Azure Data Studio.

    Regards,

    Oury

    0 comments
  3. Taswar Hussain 31 Reputation points
    2023-02-02T12:43:54.28+00:00

    Source: Azure SQL Virtual Machine

    Target: Azure SQL Server ( Elastic Pool)

    My Database is live for all users. I want 0 downtimes during migration. I have already used Microsoft Data Migration Assistant but it is very slow for the migration

    For example:

    Data Migration Assistant will migrate 2G data transfer in 4 mint (Bak to bacpac)

    MY DB Size is 300Gb = (300/2)*4 = 600 mint

    Can you suggest a fast way to migration?

    0 comments
  4. Alberto Morillo 32,806 Reputation points MVP
    2023-02-02T13:33:43.19+00:00

    Use Azure Database Migration Service (instead of DMA) and the Azure SQL Migration extension for Azure Data Studio to migrate databases from an on-premises instance of SQL Server to Azure SQL Database (preview) offline and with minimal downtime. Click here to get a step-by-step procedure. Azure Data Studio with the extension is a lot faster than DMA.

    0 comments