Forum Discussion

SARAVAB_1's avatar
SARAVAB_1
Frequent Visitor
1 year ago
Solved

PostgreSQL on AWS to Microsoft Fabric

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....
data engineering
  • nilendraFabric's avatar
    nilendraFabric
    1 year ago

    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 

v-pnaroju-msft's avatar
v-pnaroju-msft
Community Support
1 year ago

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.