Data Migration Service
- thierry sinassamy
Depending on what database we actually work with, there are other tools available. So, different scenario are possible.
Azure Migrate Project houses metadata reagrding assessment findings and migration activities.
Step 1 : Evaluate → checks compatibility and readiness for migration.
Step 2 : DMa is used to migrate the schema of DB to the destination service.
Step 3 : Data is migrated (online or offline) using DB Migration Service.
Difference between Online or Offline Migration | |
|---|---|
Online | Offline |
Continous synchronization of live data | Requires a shutdown of the soruce DB at the start of the migration |
Allows a seamless cutover to minimize downtime. | Causes downtime for the service. |
Workflow of migration process/Architecture de la migration - high-level
SQL Server as source : An on-premises instance of SQL Server that's in a private cloud or an instance of SQL Server on a virtual machine in a public cloud. SQL Server 2008 and later versions on Windows or Linux are supported.
Target Azure SQL : upported Azure SQL targets are Azure SQL Managed Instance, SQL Server on Azure Virtual Machines and Azure SQL Database.
Network File Share as source : A Server Message Block (SMB) network file share where backup files are stored for the databases to be migrated. Azure storage blob containers and Azure storage file share also are supported.
Azure Data Studio : Download and install the Azure SQL Migration extension for Azure Data Studio.
Azure Database Migration Service : An Azure service that orchestrates migration pipelines to do data movement activities from an on-premises environment to Azure. Database Migration Service is associated with the Azure Data Factory self-hosted integration runtime and provides the capability to register and monitor the self-hosted integration runtime.
Self-hosted integration runtime: Install a self-hosted integration runtime on a computer that can connect to the source SQL Server instance and to the location of the backup file. Database Migration Service provides the authentication keys and registers the self-hosted integration runtime.
Backup files upload to your Azure storage account: Database Migration Service uses a self-hosted integration runtime to upload valid backup files from the on-premises backup location to your Azure storage account. Data movement activities and pipelines are automatically created in the migration workflow to upload the backup files.
Restore backups on target Azure SQL: Database Migration Service restores backup files from your Azure storage account to the supported target Azure SQL instance.