Azure Database Migration Service Cheat Sheet 

• Accelerates the migration of your data to Azure.
• Enables seamless migrations from multiple database sources.
• To perform an online migration, you need to create an instance based on the premium pricing tier.

Features

• Migrates your database and server objects with minimal downtime.
• Supports Microsoft SQL Server, MySQL, PostgreSQL, MongoDB, and Oracle migration to Azure from on-premises, other cloud providers, and other Azure regions.

• You can use DMS for both operational database and data warehouse migrations.
• Automate the migration of data with Azure PowerShell.
• Use Azure Migrate to discover your on-premises data estate and assess migration readiness.
• You can create up to 2 DMS services per subscription.
• Support for Azure SQL Managed Instance offline migrations now allows moving databases to Azure SQL Managed Instance with minimal downtime.
• Azure Database Migration Service is now integrated into Azure Migrate as the Azure Database Migration Service tool, providing a unified migration experience from assessment to migration.
• Provides enhanced monitoring and troubleshooting through the Azure portal.

Migration Types

• Online migrations provide minimal downtime by continuously syncing data until cutover; requires premium tier.
• Offline migrations complete during a single migration window with some downtime; available with standard tier.
• Hybrid approach allows testing with offline migration before performing online cutover.

Azure Database Migration ServicePricing

• Offline migrations of the DMS Standard tier are free to use.
• DMS premium tier is billed at an hourly rate based on the provisioned compute capacity.
• Standard tier supports offline migrations only, while premium tier supports both offline and online migrations with continuous data sync.

Want to learn more about Azure? Watch the official Microsoft Azure YouTube channel’s video series called Azure Tips and Tricks.

Azure DMS Resources:

https://docs.microsoft.com/en-us/azure/dms/dms-overview
https://azure.microsoft.com/en-us/services/database-migration/