Azure Database Migration Service is a fully managed service designed to enable seamless migrations from multiple database sources to Azure data platforms with minimal downtime.

Previously you can use DMS only via Azure Database Studio or Azure PowerShell /cli. Now with the addition of Azure Portal experience to DMS, it enables one more way to perform SQL to Azure SQL Target migration using DMS along with “Azure SQL Migration” extension in ADS, and Azure PS/CLI.

DMS’s Azure portal experience will allow users to perform following tasks:
Create DMS service: Like DMS (classic), Users can create a new Database Migration Service from the Azure Portal itself.
Start a SQL migration: Users can launch the desired migration wizard to perform database migrations from SQL Server to the following Azure targets:
Azure SQL Managed Instance (Offline / Online)
Azure SQL Virtual Machine (Offline / Online)
Azure SQL Database (Offline)
SHIR configuration: Users can access an integration runtime configuration page to download Self Hosted Integrated Runtime software and copy registration keys to configure an Integration Runtime with DMS service.
Migration checklist and documentation: Based upon the Azure SQL Target selections, users get a list of migration prerequisites, documentation, and tutorial links.

00:23 Introductions
01:01 What is Azure Migration Service?
02:01 Demo of the Portal Migration Experience
03:24 Service in action
03:54 Practical example of onprem SQL Server to Azure SQL Database
08:11 Online and Offline Migrations explained
08:46 Tips and Tricks
09:14 Closing

Let's connect:
Twitter Anna Hoffman,   / analyticanna  
Twitter AzureSQL, https://aka.ms/azuresqltw

✔ Additional Resources:
https://ms.portal.azure.com/#create/M...
https://learn.microsoft.com/enus/azu...
https://github.com/Azure/SQLMigratio...
https://learn.microsoft.com/enus/azu...

Watch even more Data Exposed episodes: https://aka.ms/dataexposedyt
Subscribe to our channels for even more SQL tips:
Microsoft Azure SQL: https://aka.ms/msazuresqlyt
Microsoft SQL Server: https://aka.ms/mssqlserveryt
Microsoft Developer: https://aka.ms/microsoftdeveloperyt

#AzureSQL #SQL #LearnSQL