Migrating SQL DB from VM A at on-premises via VM B (which has Azure Data Studio installed) to VM C in Azure

Hi VJ-8370

Greeting!

As I understand it, you're looking for help with database migration from one VM to another VM.

You can use the Azure SQL Migration extension for Azure Data Studio to facilitate your SQL database migration from VM A (on-premises) to VM C (Azure) via VM B, which has Azure Data Studio installed. Since ExpressRoute is set up between VM B and Azure, this method ensures a secure and efficient migration.

Steps to migrate:

1. Install the Azure SQL Migration extension in Azure Data Studio on VM B.
2. Assess the source database on VM A using the extension to check migration readiness.
3. Choose the migration mode:
   • Online Migration: Minimal downtime, database remains accessible.
   • Offline Migration: Requires downtime during migration.
4. Configure the migration settings:
   • Select VM C (Azure SQL target).
   • Provide database backup location (either a network file share or Azure Blob Storage).
5. Initiate the migration using Azure Database Migration Service.
6. Monitor the migration progress and perform cutover once completed. Continuous sync to migrate large database: when migrating large SQL databases via Azure Data Studio, you can leverage online migration with Azure Database Migration Service (DMS). This ensures minimal downtime and keeps your source and target databases in sync. Steps to set up continuous sync:
   1. Use Online Migration Mode in Azure SQL Migration extension.
   2. Enable Transactional Replication or Log Shipping for ongoing sync.
   3. Configure Self-Hosted Integration Runtime on VM B to access backups.
   4. Use Azure Blob Storage for incremental backups and restore.
   5. Monitor Migration Progress via Azure Data Studio and Azure Portal.
   6. Perform Cutover once the final sync is complete. Please refer the Microsoft official documentation more help and clear steps.
   7. https://www.sqlservercentral.com/articles/azure-sql-migrations-using-azure-data-studio
   8. https://learn.microsoft.com/en-us/AZURE/dms/migration-using-azure-data-studio?tabs=azure-sql-mi
   If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.