Explore the migration lifecycle for SQL Server 2008/R2 instances reaching End of Support (EOS) in this 57-minute conference talk. Learn about the Azure Database Migration Service and related tools that facilitate near-zero downtime migrations to Azure. Discover various modernization approaches, including Azure IaaS with Extended Security Updates (ESU) for app migration. Gain insights into using Data Migration Assistant (DMA) for feature parity and compatibility assessments. Understand online migration techniques using backup and restore technology, as well as Managed Instance migrations with the Azure Database Migration Service. Review supported migration scenarios, Fast Track for Azure, and access additional migration resources to ensure a smooth transition from SQL Server 2008/R2 to modern Azure solutions.
Overview
Syllabus
Intro
Technical Assistance
Deadline to act before end of support
End of Support - What are the Options?
Approaches to modernization
Tools and services for your migration journey
App Migration — Azure laaS (ESU)
DMA -feature parity assessment
DMA -Compatibility assessment
Online migration with backup and restore technology
Managed Instance migrations using the Azure Database Migration Service
Azure Database Migration supported scenarios
Fast Track for Azure
Other sessions
Migration resources
Taught by
PASS Data Community Summit
Related Courses
-
Migrate SQL Server workloads to Azure SQL
-
End of Support for SQL Server 2008 - R2 - 20 Years of PASS
-
Architect migration, business continuity, and disaster recovery in Azure
-
Modernizing SQL Server
-
Deep Dive with Data Migration Tools and Azure Database Migration Service - DMS
-
SQL Managed Instance - A Fully Managed SQL Server in the Cloud
