1. Home
  2. Training Library
  3. Microsoft Azure
  4. Courses
  5. Azure SQL - Designing and Implementing a Migration Plan

Azure SQL - Designing and Implementing a Migration Plan

Azure SQL: Designing and Implementing a Migration Plan - Introduction
Overview
Difficulty
Intermediate
Duration
49m
Students
55
Ratings
5/5
starstarstarstarstar
Description

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 course 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 course 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 course, you should be familiar with general database and cloud concepts.

 

Transcript

Hi, and welcome to this Azure SQL Designing and Implementing a Migration Plan course. We start the migration journey by evaluating your current database environment in relation to Azure SQL database offerings. Having identified the target environment, we'll look at planning the migration to minimize downtime and cost. Finally, we'll explore the different methods and tools to carry out the migration and how you might go about it.

As far as prerequisites go, this is not an overly technical course, so familiarity with general database and cloud concepts will be sufficient for you to understand and appreciate this content.

My name is Hallam Webber, and I'll be your instructor for this course. We welcome all comments and feedback, so please feel free to reach out to us at support@cloudacademy.com with any questions or comments. Let's dive in.

About the Author
Avatar
Hallam Webber
Software Architect
Students
15315
Courses
28
Learning Paths
3

Hallam is a software architect with over 20 years experience across a wide range of industries. He began his software career as a  Delphi/Interbase disciple but changed his allegiance to Microsoft with its deep and broad ecosystem. While Hallam has designed and crafted custom software utilizing web, mobile and desktop technologies, good quality reliable data is the key to a successful solution. The challenge of quickly turning data into useful information for digestion by humans and machines has led Hallam to specialize in database design and process automation. Showing customers how leverage new technology to change and improve their business processes is one of the key drivers keeping Hallam coming back to the keyboard.