Azure postgres to on premise postgres

Salim Mohammed Ali 20 Reputation points
2023-07-05T14:40:55.6533333+00:00

HI,

We are in process of migrating the postgres on premise to azure postgres . Currently defining our rollback strategy we need to know if there any way to migrate the database changes from azure to on premise (in-case we need a rollback)

Azure Database Migration service
Azure Database for PostgreSQL
0 comments
Accepted answer
  1. Rahul Randive 9,091 Reputation points Microsoft Employee
    2023-07-05T16:42:47.3633333+00:00

    Hi @Salim Mohammed Ali

    For migrating from Azure Database for PostgreSql to on-premise, I believe there is no service or tool handy at this moment but below is the article you can refer to.

    Here we can 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://video2.skills-academy.com/en-us/azure/data-factory/connector-azure-database-for-postgresql

    Hope this helps!

    Let us know if you have any questions or need additional information.

    Thank you!

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest