Online migration to Azure sql database

Question

I just thought there is an option to do ONLINE migration from on-prem sql server to Azure SQL database (not MI) , using DMS

but there is no option for you to choose now .

Answer 1

Hi @sakuraime
Thank You for posting in Q & A.

Before you can migrate data from a SQL Server instance to a single database or pooled database in Azure SQL Database, you need to assess the SQL Server database for any blocking issues that might prevent migration.
https://learn.microsoft.com/en-us/azure/dms/tutorial-sql-server-to-azure-sql#assess-your-on-premises-database

Tutorial: Migrate SQL Server to Azure SQL Database using DMS

step-by-step article Migrate SQL Server to Azure SQL Database
https://datamigration.microsoft.com/scenario/sql-to-azuresqldb?step=1

1. Before you start
2. Pre-migration
3. Migration
4. Post-migration

If the Answer is helpful, please click Accept Answer and up-vote, this can be beneficial to other community members.

Answer 2

Azure SQL DB online migration using DMS is no longer available.

In our continued effort to provide you with the best migration experience, we replaced SQL Server to Azure SQL DB online migration with robust and reliable offline (aka onetime) migration. With this method you may incur migration downtime during the database migration.

The DMS service provide estimated downtimes for the selected databases, if those downtimes are not acceptable, we recommend you consider migrating to Azure SQL DB Managed Instance that provide online migration, minimize your downtime to migration cutover time.

If you still plan to migrate to Azure SQL DB and minimize migration downtime, please contact us at DMSfeedback@microsoft.com that we can help optimizing your migration approach to meet your migration downtimes.