Challenge 1: Discovery and Assessment

< Previous Challenge - Home - Next Challenge >

Introduction

Discover and assess aspects of the database environment that you will be migrating. You will also deploy an Azure DB for MySQL and/or PostgreSQL.

Description

In this challenge you will be connecting to your “on-prem” environment using the database tools you installed in the prerequisites. You will take an inventory of the database(s) that need to be migrated, check the database versions, check the database engine and determine if they are ready to migrate to Azure. You can use either the GUI or CLI tools mentioned in the Prerequisites to get this information. In an actual migration you would need to determine CPU/memory and I/O requirements as well. However, since this is not a production environment you will instead select either the default configuration for Azure DB for Postgres/MySQL Single Server (4 cores/100GB) or use the Production (Small/Medium-size) option for Workload type for Azure DB for Postgres/MySQL Flexible Server.

Success Criteria

• You have connected to the “on-prem” databases using the database tools and taken an inventory of the databases such as the database version, size, schema objects, and dependencies between schema objects.
• You have verified that the “on-prem” database versions and size are supported in Azure DB for PostgreSQL/MySQL.
• You have checked for any other database compatibility issues that need to be resolved before migrating it to Azure. For specific compatibilty issues, refer to the Limitations pages below.
• You have selected the appropriate database service tier (e.g. General Purpose or Memory Optimized) and can explain to your coach when to use which service tier
• You can explain to your coach the different database deployment option (Single Server/Flexible Server and HyperScale (PostgreSQL only))
• You have deployed Azure DB for Postgres and/or Azure DB for MySQL with the appropriate options

Hints

• For Oracle you can use either GUI/CLI database tools or ora2pg to get the information requested. There is already an ora2pg container deployed in your environment that you can use.

References

• Limitations in Azure Database for MySQL
• Migrating MySQL On-Premises to Azure Database for MySQL
• Limitations in Azure Database for Postgres
• Migrate Oracle to Azure Database for Postgres
• White Paper: Oracle to Azure Database for Postgres migration guide
• Choose the right MySQL Server option in Azure
• Pricing tiers in Azure Database for PostgreSQL - Single Server
• Azure Database for PostgreSQL pricing
• Create an Azure Database for MySQL server
• Create an Azure Database for PostgreSQL server
• Firewall rules in Azure Database for PostgreSQL - Single Server
• Firewall rules in Azure Database for MySQL