Migrate Azure Database for PostgreSQL to On-Premise PostgreSQL

vijay ande 1 Reputation point
2020-09-10T17:30:48.273+00:00

I want to migrate my Azure Database for PostgreSQL to my On-Premise PostgreSQL. How do I do it ?

Does Azure supports any such migration tool for moving or copying databases from Azure to On-Premise and vice-versa.

please advice.

Azure Database for PostgreSQL
No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Anurag Sharma 17,271 Reputation points
    2020-09-11T05:37:47.903+00:00

    Hi @vijay ande , thanks for reaching out to us. Please refer below for more details.

    1) For migrating from On-Premise to Azure Database for PostgreSql, you can utilize the 'Azure Database Migration Services' service. below article has step by step process of doing the same.
    https://learn.microsoft.com/en-us/azure/dms/tutorial-rds-postgresql-server-azure-db-for-postgresql-online

    You can also achieve the same using Azure CLI, please refer below article which is very straight forward and if this is one time activity, you can prefer this approach too.
    https://learn.microsoft.com/en-us/azure/dms/tutorial-postgresql-azure-postgresql-online

    2) For migrating from Azure Database for PostgreSql to on-premise, there is no service or tool handy but below is the article you can refer to. Here we create a .sql dump file from Azure Postgresql database and then you can import the dump .sql file in your on-premise database.
    https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/backup-azure-database-for-postgresql-to-a-blob-storage/ba-p/803343

    You can also use the Azure Data Factory to achieve the desired functionality as well:
    https://learn.microsoft.com/en-us/azure/data-factory/connector-azure-database-for-postgresql

    Please let us know if you have any query or looking for some more details.