Migrate on-premises PostgreSQL databases to Azure Database for PostgreSQL

Intermediate
Data Engineer
Azure

In this module, you'll learn about the benefits of migrating PostgreSQL workloads to Azure, you'll see how to create an Azure Database for PostgreSQL instance and how to migrate on-premises PostgreSQL databases to Azure.

Learning objectives

By the end of this module, you'll be able to:

  • Describe the features and limitations of Azure Database for PostgreSQL.
  • Migrate an on-premises PostgreSQL database to Azure Database for PostgreSQL.
  • Reconfigure existing applications that use your on-premises PostgreSQL databases to connect to Azure Database for PostgreSQL.

Prerequisites

  • Knowledge of MySQL or PostgreSQL database management systems, including application development for these systems, administration, backup, and recovery techniques, such as import/export and backup/restore.
  • Knowledge of Azure fundamental concepts, and experience using the Azure portal.