New Azure Portal experience for Azure Database Migration Service | Data Exposed

Video Description

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 on-prem 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, https://twitter.com/AnalyticAnna Twitter - AzureSQL, https://aka.ms/azuresqltw ✔️ Additional Resources: https://ms.portal.azure.com/#create/Microsoft.AzureDMS https://learn.microsoft.com/en-us/azure/dms/dms-overview https://github.com/Azure/SQL-Migration-AzureSQL-PoC https://learn.microsoft.com/en-us/azure/dms/migration-using-azure-data-studio?tabs=azure-sql-mi 🔴 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