Module 1: Migrate to Azure SQL DB for MySQL & PostgreSQL
This module describes the benefits and architecture of Azure SQL DB.
Lessons
- OSS databases overview
- Common OSS database workloads
- Customer challenges in migration
Lab: Creating source OSS databases
- Installation of Postgres migration DB server
- Installation of MySQL migration DB server
- Backups / data dumps from Postgres / MySQL
- Restore from data dumps
After completing this module, students will be able to:
- OSS databases overview,
- Common OSS database workloads,
- Customer challenges in migration.
Module 2: Migrate on-premises MySQL to Azure SQL DB for MySQL
This module describes the benefits and process of migrating MySQL workloads to Azure SQL DB.
Lessons
- Configure and Manage Azure SQL DB for MySQL
- Migrate on-premises MySQL to SQL DB for MySQL
- Application Migration
- Post-migration considerations
Lab: Migrating MySQL DB Workloads to Azure SQL DB
- Migrating MySQL DB Workloads to Azure SQL DB
- Define Source and Target DBs
- Perform Migration
- Verify Migration
After completing this module, students will be able to:
- Configure and Manage Azure SQL DB for MySQL,
- Migrate on-premises MySQL to SQL DB for MySQL,
- Application Migration,
- Post-migration considerations.
Module 3: Migrate on-premises PostgreSQL to Azure SQL DB for PostgreSQL
This module describes the benefits and process of migrating PostgreSQL DB workloads to Azure SQL DB
Lessons
- Configure and Manage Azure SQL DB for PostgreSQL
- Migrate on-premises MySQL to SQL DB for PostgreSQL
- Application Migration
- Post-migration considerations
Lab: Migrating PostgreSQL DB Workloads to Azure SQL DB
- Configure Azure SQL DB for PostgreSQL
- Define Source and Target DBs
- Perform Migration
- Verify Migration
After completing this module, students will be able to:
- Configure and Manage Azure SQL DB for PostgreSQL,
- Migrate on-premises MySQL to SQL DB for PostgreSQL,
- Application Migration,
- Post-migration considerations.