Share via

Using Azure Dms is it possible to migarte sql databse of 5Tb to azure Vm with ? What are limitations and known issues while migrating huge dbs to azure vm with azure DMS tool?

Vishnuvardhan Settipally 1 Reputation point
2020-12-18T09:51:35.783+00:00

We are planning to migrate 5 Tb of sql db to azure Vm with help of azure DMS ? does dms support sql db with huge sizes like this?

Azure Dms does supports only offline migration for azure vm .

what is avg time taken by for migrating sql db
with 100 gb size ?

Does any other factors create an issue while we migration of huge dbs ?

Azure Database Migration service
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.
511 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. CathyJi-MSFT 21,121 Reputation points Microsoft Vendor
    2020-12-21T08:52:27.337+00:00

    Hi @Vishnuvardhan Settipally ,

    > does dms support sql db with huge sizes like this?

    Yes, it is supported. According to MS document, Azure DMS is recommended for large (in terms of number and size of databases) migrations – DMS can migrate databases at scale.

    > Does any other factors create an issue while we migration of huge dbs ?

    Suggest you check if your environment meet the requirements of using Azure DMS.

    Azure Database Migration Service prerequisites that are common across all supported migration scenarios include the need to:

    •Create a Microsoft Azure Virtual Network for Azure Database Migration Service by using the Azure Resource Manager deployment model, which provides site-to-site connectivity to your on-premises source servers by using either ExpressRoute or VPN.

    •Ensure that your virtual network Network Security Group rules don't block the following communication ports 443, 53, 5671-5672, 9350-9354, 445, 12000. For more detail on virtual network NSG traffic filtering, see the article Filter network traffic with network security groups.

    •When using a firewall appliance in front of your source database(s), you may need to add firewall rules to allow Azure Database Migration Service to access the source database(s) for migration.

    Please refer to this MS document to get more information.

    Best regards,
    Cathy

    If the response is helpful, please click "Accept Answer" and upvote it, thank you.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.
  2. CathyJi-MSFT 21,121 Reputation points Microsoft Vendor
    2020-12-24T08:17:46.15+00:00

    Hi @Vishnuvardhan Settipally ,

    Sorry for reply late.

    > what is average migration time for 500 gb of db with Dms?

    It depends on your environment. Some factors will effect this. According to MS document,

    Are there any recommendations for optimizing the performance of Azure Database Migration Service? You can do a few things to speed up your database migration using the service:

    •Use the multi CPU General Purpose Pricing Tier when you create your service instance to allow the service to take advantage of multiple vCPUs for parallelization and faster data transfer.
    •Temporarily scale up your Azure SQL Database target instance to the Premium tier SKU during the data migration operation to minimize Azure SQL Database throttling that may impact data transfer activities when using lower-level SKUs.

    Hope this could help you.

    > does Dms resumes migration or does it restart migration ?

    I do not have Azure environment to test this for you. I could not give you a confirm answer.

    Best regards,
    Cathy

    If the response is helpful, please click "Accept Answer" and upvote it, thank you.