Azure SQL - Designing and Implementing a Migration Plan

Focused View

Hallam Webber

49:29

14 View

1. Azure SQL Designing and Implementing a Migration Plan - Introduction.mp4

01:00

2. Evaluating Your Current Database Environment.mp4

02:14

3. Migration Scenarios.mp4

04:14

4. Data Transfer.mp4

03:29

5. Azure Migrate.mp4

04:38

6. Data Migration Service Demo.mp4

08:48

7. Data Migration Assistant Assessment Demo.mp4

04:16

8. Data Migration Assistant Migration Demo.mp4

04:15

9. SQL Server Migration Assistant Demo.mp4

06:13

10. MySQL Migration Demo.mp4

04:44

11. Azure SQL- Designing and Implementing a Migration Plan - Summary.mp4

05:38

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 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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

SQL Server

Microsoft SQL

Microsoft Azure

Hallam Webber

Instructor's Courses

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.

Cloud Academy

View courses Cloud Academy

Join thousands of users in achieving your personal goals through Cloud Academy. Score job-ready tech skills that you can practice in a real environment, without the risk of extra costs or making mistakes. It’s simply the smartest way to gain certifications and get career-ready.