Sign in to confirm you’re not a bot
This helps protect our community. Learn more

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

Microsoft Developer
592K subscribers
<__slot-el>
<__slot-el>
3.9K views 1 year ago #LearnSQL #SQL #AzureSQL
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:  …...more
...more
New Azure Portal experience for Azure Database Migration Service | Data Exposed
77Likes
3,974Views
2023Oct 19
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,   / analyticanna   Twitter - AzureSQL, https://aka.ms/azuresqltw ✔️ Additional Resources: https://ms.portal.azure.com/#create/M... https://learn.microsoft.com/en-us/azu... https://github.com/Azure/SQL-Migratio... https://learn.microsoft.com/en-us/azu... 🔴 Watch even more Data Exposed episodes: https://aka.ms/dataexposedyt 🔔 Subscribe to our channels for even more SQL tips: #AzureSQL #SQL #LearnSQL

Follow along using the transcript.

Microsoft Developer

592K subscribers