Unable to copy the local postgresql database to azure postgresql database

Question

I'm unable to find the YAML examples of copying local postgresql db to azure postgres sql db through azure devops ci/cd pipelines.

Here I'm failing. If I give Script Location as Script Path. Agent is unable find the path of location.sql file located in project repository.

Could anyone help me in giving the YAML Code steps for copying the local postgres database data to Azure database for postgreSQL instance?

Answer 1

Hi billa •,

Thanks for using Microsoft Q&A forum.

As I understand, you are Unable to copy the local postgresql database to azure postgresql database.

Could you please try using Azure Data Factory or Azure Synapse Analytics to achieve this illustrated here https://learn.microsoft.com/en-us/azure/data-factory/connector-azure-database-for-postgresql?tabs=data-factory.

Do let us know if you face any issue.

And if you are using Azure DevOps, we recommend you to write your query in Azure DevOps forum so that the community there could you you.

Thank you.