@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
How to copy database from Higher Environment to lower environment.
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 ?
2 answers
Sort by: Most helpful
-
Oury Ba-MSFT 20,106 Reputation points Microsoft Employee
2024-01-12T21:48:56.12+00:00 -
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.
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