question

SubashRajakumar-6070 avatar image
0 Votes"
SubashRajakumar-6070 asked AmeliaGu-msft commented

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

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.

azure-sql-databaseazure-migratesql-server-migrationsql-server-migration-assistant
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @SubashRajakumar-6070,

Did the answers help you?
Please feel free to let us know if you have any other question.
If you find any post in the thread is helpful, you could kindly accept it as answer.

Best Regards,
Amelia

0 Votes 0 ·
KalyanChanumolu-MSFT avatar image
1 Vote"
KalyanChanumolu-MSFT answered KalyanChanumolu-MSFT edited

@SubashRajakumar-6070 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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AmeliaGu-msft avatar image
1 Vote"
AmeliaGu-msft answered

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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.