Search code examples
databasepostgresqlazureclouddatabase-replication

Replicate PostgrSQL on-premise to Azure Database for PostgreSQL

my client wants to replicate their PostgreSQL on-premise database to Azure for security resonse.
How can I achive these the easiest way? Using Data Factory? I dont have access to client servers so Im looking for least configuration steps to perform.

Solution

  • Azure suggest us use DMS(Database Migration Service) to migrate/replicate database. It provides many ways to help us migrate/replicate on-premise PostgreSQL to Azure SQL database for PostgreSQL.

    Please ref these tutorials:

    1. Tutorial: Migrate PostgreSQL to Azure DB for PostgreSQL online using DMS via the Azure portal
    2. Tutorial: Migrate PostgreSQL to Azure DB for PostgreSQL online using DMS via the Azure CLI

    Data Factory is mostly used for migrate the data between source and sink, won't copy the schema of the database.

    But both of ways all need access to the source on-premise PostgreSQL database, without the access, we can't do the migration or replication.

    HTH.