This module describes the benefits and architecture of Azure SQL DB.

Lessons

• OSS databases overview
• Common OSS database workloads
• Customer challenges in migration

• Installation of Postgres migration DB server
• Installation of MySQL migration DB server
• Backups / data dumps from Postgres / MySQL
• Restore from data dumps

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

At the end of this module, the 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

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

At the end of this module, the 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