Hello, I have all my tables in Azure SQL. Initially we decided to go ahead with Azure SQL, because of some reasons we decided to move to Postgres Instead of azure SQL. I would like to transfer the data from Azure SQL to PostgresSQL. I am new to this Azure platform. Could anyone help me with this? Note: Our client don't want to use ADF. Can anyone suggest other options to achieve this? Thank you.

Hi @Satya Sri , Welcome to Microsoft Q&A platform and thanks for using Azure services. As I understand your question, you want to transfer data from Azure SQL Database to Azure PostgresSQL. This could be achieved by using Azure Data Factory Copy Activity. Detailed description of the same is given at this link: data-migration-from-azure-sql-database-to-azure-database-for-postgresql Please try to implement the ADF pipeline to Copy data and let us know if you can do it. Do let us know if further queries. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

Azure SQL to Postgres Migration

Accepted answer

ShaktiSingh-MSFT 15,841 Reputation points

2022-12-01T05:24:15.4+00:00

Hi @Satya Sri ,

Welcome to Microsoft Q&A platform and thanks for using Azure services.

As I understand your question, you want to transfer data from Azure SQL Database to Azure PostgresSQL.

This could be achieved by using Azure Data Factory Copy Activity.

Detailed description of the same is given at this link: data-migration-from-azure-sql-database-to-azure-database-for-postgresql

Please try to implement the ADF pipeline to Copy data and let us know if you can do it. Do let us know if further queries.

If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.
Please sign in to rate this answer.
Satya Sri 46 Reputation points

2022-12-02T05:10:48.813+00:00

Thank you. I agree with you.
My organization does not want to use ADF Pipelines. Is there any alternative solution for this?

Thank you.

ShaktiSingh-MSFT 15,841 Reputation points

2022-12-02T09:39:04.06+00:00

Hi @Satya Sri ,

Let me check on this internally and will get back to you.

Satya Sri 46 Reputation points

2022-12-02T14:58:31.377+00:00

Sure. Thank you.

Satya Sri 46 Reputation points

2022-12-03T06:05:39.42+00:00

@ShaktiSingh-MSFT Thank you for your help. Could you please suggest other options as our client is not interested in using ADF.

ShaktiSingh-MSFT 15,841 Reputation points

2022-12-05T09:58:28.02+00:00

Hi @Satya Sri ,

I am checking internally if it is possible. Will get back to you with the update. Thanks for your patience.

ShaktiSingh-MSFT 15,841 Reputation points

2022-12-06T05:23:28.9+00:00

Hi @Satya Sri ,

As per the internal team response, Migration from Azure SQL to Azure Postgres SQL is not a typical path and that’s why we don’t have 1st party tools to take care of this scenario. If you do not want to use ADF, other option could be our 3rd party Striim offering where you can use 1 free license to migrate this database.

Reference video on usage:
Striim Product Demo PostgreSQL To Cloud SQL For PostgreSQL

Hope this helps.

Satya Sri 46 Reputation points

2022-12-06T18:13:02.153+00:00

Thank you
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Azure SQL to Postgres Migration

0 additional answers

Your answer