Migrating SQL Server to Azure Manage Instance using DMS / LRS by Gilda Alvarez

About this video

• Video Title: Migrating SQL Server to Azure Manage Instance using DMS / LRS by Gilda Alvarez
• Channel: Data Platform WIT
• Speakers: Gilda Alvarez
• Duration: 00:40:24

Overview

This video provides a comprehensive guide on migrating SQL Server databases to Azure Managed Instance using Azure Data Migration Service (DMS) and Log Replay Service (LRS). The presenter, Gilda Alvarez, walks through the prerequisites, the migration process itself, and offers insights into best practices for minimizing downtime and ensuring a successful transition to the cloud.

Key takeaways

• Migration Tools: The primary tools discussed are Azure Data Migration Service (DMS) and Azure Data Studio with the Azure SQL Migration extension. The presenter notes that Azure Data Studio's functionality will eventually be integrated into the Azure portal.
• Migration Methods: Both online and offline migration strategies are presented, with an emphasis on online migration for minimal downtime.
• Backup Strategy: Backups are directed to an Azure storage account, and it's critical that each database has its own folder within the container for DMS to function correctly.
• Azure Managed Instance (MI) Setup: The process of creating an Azure Managed Instance is demonstrated, highlighting the need for appropriate permissions (Contributor, Reader roles) and network configuration.
• DMS Process: The video details how DMS connects to the on-premises database, leverages the backup history from the storage account, and restores it to the Azure Managed Instance.
• Log Replay Service (LRS): LRS is presented as an alternative for greater control during migration, especially for large or critical environments, though it requires more manual scripting and is described as "temperamental."
• Azure Arc: The presenter discusses Azure Arc as the future direction for managing hybrid cloud solutions, including SQL Server migrations.
• Azure SQL Database vs. Managed Instance: The challenges of migrating to Azure SQL Database, particularly with cross-database queries and domain usernames, are contrasted with the benefits of Azure Managed Instance as a closer PaaS equivalent to on-premises environments.
• Importance of Testing: The presenter strongly advises thorough testing and validation before attempting production migrations, comparing complex migrations to "open heart surgeries."