Azure SQL - Designing and Implementing a Migration Plan

Once you've decided to take advantage of cloud technology, resources, and scale, and have set up an Azure infrastructure, there is the small matter of transferring your existing data to the cloud. A migration is successful when the target production system is up and running correctly with the minimum impact on the business' operation. Achieving this requires knowing what data issues you will have in the new environment and minimizing system downtime while the data is transferred. This lesson looks at strategies and tools to achieve an optimal migration.

Learning Objectives

• Understand the underlying concepts of migrating relational databases to Azure
• Explore the factors in determining the optimal migration scenario as well as those affecting the physical movement of data from on-premises to Azure
• Learn the different tools and services to aid in discovery, assessment, and migration
• Learn how to migrate an on-premises SQL Server DB to Azure SQL Managed Instance using the Data Migration Service
• Use Data Migration Assistant to migrate on-Premises SQL Server databases to Azure SQL DB
• Migrate MySQL to Azure MySQL using MySQL Workbench
• Migrate a MySQL database to Azure SQL Server using SQL Server Migration Assistant

Intended Audience

This lesson is ideal for anyone looking to migrate their existing on-premise database environment to an Azure SQL database solution.

Prerequisites

To get the most out of this lesson, you should be familiar with general database and cloud concepts.