How to copy database from Higher Environment to lower environment.

VISHAL DURGULE 0 Reputation points
2024-01-12T13:58:30.6233333+00:00

I have azure postgresql server for all environment with different subscriptions. I have to copy the all data from higher enviornment database to lower environment database. Does there any azure service I can use for this ?

Azure Database for PostgreSQL
{count} votes

2 answers

Sort by: Most helpful
  1. Oury Ba-MSFT 20,106 Reputation points Microsoft Employee
    2024-01-12T21:48:56.12+00:00

    @VISHAL DURGULE
    Thank you for reaching out. There are a few options available like dump and restore and Azure Data Factory or Synapse Analytics. You can consider using AZ copy command also https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/moving-data-with-postgresql-copy-and-copy-commands/ba-p/1561266 You can do it with different subscriptions. Subscriptions do not matter as long as you have access (Access is at AAD level for managed identities). Regards, Oury


  2. Sedat SALMAN 14,150 Reputation points MVP
    2024-01-12T21:50:49.4966667+00:00

    you can utilize some Azure services to do this

    you can use Azure Pipelines, which allows for more automated, repeatable processes.

    https://dev.to/chris_mckelt/using-azure-pipelines-to-restore-a-production-database-to-another-environment-51lo

    or Utilize Azure Data Factory or Azure Synapse for data copying. These services offer capabilities like copying data in parallel, and they support various configurations for different scenarios.

    https://learn.microsoft.com/en-us/azure/data-factory/connector-azure-database-for-postgresql

    https://learn.microsoft.com/en-us/fabric/data-factory/connector-azure-database-for-postgresql-copy-activity

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.