-
Course
- Cloud
- Data
Migrating to Azure SQL Managed Instance
Successfully migrating databases to Azure SQL Managed Instance requires careful planning and correct use of the available tools. This course will teach you how to plan and execute migrations of both Microsoft SQL Server and third-party databases.
What you'll learn
Migrating to Azure SQL Managed Instance requires more than simply moving databases—it takes careful planning, the right tools, and an understanding of unique migration challenges. In this course, Migrating to Azure SQL Managed Instance, you’ll gain the ability to plan and execute migrations from both Microsoft SQL Server and third-party databases with confidence.
First, you’ll explore when and why to migrate by identifying typical use cases, benefits, and challenges for SQL Server and popular third-party platforms such as Oracle, MySQL, and DB2. Next, you’ll learn how to plan a successful migration, from pre-migration assessments and environment preparation to post-migration validation. Then, you’ll discover how to choose the right tools for the migration, comparing solutions such as Azure Migrate, Managed Instance Link, Backup and Restore, SSMA, and DMS. Finally, you’ll put it all into practice with hands-on demos.
When you’re finished with this course, you’ll have the knowledge and practical experience needed to plan, execute, and validate migrations to Azure SQL Managed Instance, whether you’re moving from SQL Server or third-party database platforms.
Table of contents
About the author
For as long as I can remember I’ve been drawn to technology, eager to soak up everything I could about it. Over my 20-year career—spanning roles in technical support, systems and database administration, technical training, and people leadership—I’ve discovered that one of my greatest joys is sharing that passion with others. These days, my focus is on data, which I believe is the cornerstone of all technology, driving innovation across every area of IT. I’m also a big fan of the cloud and automation, and I love finding ways to streamline processes with tools like PowerShell. Outside of work I enjoy spending time with my family, volunteering with my church, and diving into a good book, movie, or video game. Whether on the page or the screen, I love a good adventure.
More Courses by Landon