MS SQL to azure sql database migration more than "XX" TB data

Question

MS SQL 2008 to azure SQL database migration more than "XX" TB data

• What are the things to consider ?
• Aware about the wizard / backup file can help but how huge data will that be a problem ?
• please share the suggestions, pricing and timing for migration can imagine.
• Wants to look for the Comparisons with all options in Azure.

Answer 1

@Subash Raja kumar Welcome to Microsoft Q&A Forums.

We have a migration guide to help you with all the options to move your database on SQL Server to Azure SQL Database.
Comparison of migration options is here

For migrating large databases, Data Migration Service (DMS) is recommended. A tutorial is here
There are no charges for using DMS in Standard Tier.
For Premium compute it is billed at 0.37$ per hour. Pricing details are here

----------

If an answer is helpful, please "Accept answer" or "Up-Vote" which might help other community members reading this thread.

Answer 2

Hi SubashRajakumar-6070,
In addition, we can generate a BACPAC in SQL Server, and then import the BACPAC to Azure SQL database. To maximize import speed by providing more and faster resources, scale your database to a higher service tier and compute size during the import process. You can then scale down after the import is successful.

Please refer to the following articles which might help:
Migrate an on-premises SQL Server database to an Azure SQL database
Export a Data-tier Application
Import a BACPAC file to a database in Azure SQL Database

Best Regards,
Amelia

---

If the answer is helpful, please click "Accept Answer" and upvote it.
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.