topic Re: PostgreSQL on AWS to Microsoft Fabric in Data Engineering

PostgreSQL on AWS to Microsoft Fabric

SARAVAB_1 — Fri, 31 Jan 2025 12:43:01 GMT

There is a request to migrate PostgreSQL on AWS to Microsoft Fabric, potentially targeting the Fabric Data Warehouse. Most of the PostgreSQL functions will be converted into Fabric Stored Procedures. I am checking with you if there is an easy way to facilitate this migration

Re: PostgreSQL on AWS to Microsoft Fabric

nilendraFabric — Fri, 31 Jan 2025 12:59:42 GMT

Hello SARAVAB_1

challenge when migrating PostgreSQL to Microsoft Fabric is converting function logic from PL/pgSQL syntax to T-SQL.

There is no fully automated way to achieve this.

tools like https://www.sqlines.com might help but it often require manual cleanup afterward, especially for complex functionality

so what you are doing at the moment seems like the only viable option.

please accept this answer and give kudos if this is helpful

Re: PostgreSQL on AWS to Microsoft Fabric

v-pnaroju-msft — Mon, 03 Feb 2025 20:30:16 GMT

Hi SARAVAB_1,

Thank you, nilendraFabric , for your response.

We would like to inquire whether the solution provided by nilendraFabric has resolved your issue. If you have identified an alternative approach, we encourage you to share it with the community to assist others facing similar challenges.

If you find the response helpful, kindly mark it as the accepted solution and provide kudos. This recognition will benefit other members seeking solutions to related queries.

Thank you.

Re: PostgreSQL on AWS to Microsoft Fabric

v-pnaroju-msft — Fri, 07 Feb 2025 18:08:41 GMT

Hi SARAVAB_1,

We wanted to check in regarding your query, as we have not heard back from you. If you have resolved the issue, sharing the solution with the community would be greatly appreciated and could help others encountering similar challenges.

If you found our response useful, kindly mark it as the accepted solution and provide kudos to guide other members.

Thank you.

Re: PostgreSQL on AWS to Microsoft Fabric

v-pnaroju-msft — Mon, 10 Feb 2025 19:17:32 GMT

Hi SARAVAB_1,

We are following up to see if your query has been resolved. Should you have identified a solution, we kindly request you to share it with the community to assist others facing similar issues.

If our response was helpful, please mark it as the accepted solution and provide kudos, as this helps the broader community.

Thank you.