Tool to convert t-sql (SQL Server) stored procedure to psql (postgresql)


Can anybody suggest a tool or share code which can help me converting large number of t-sql stored procedures in database to postgresql while migrating from SQL Server database to postgresql?

== Edited== here are some clear goals:

  1. Convert all sps to postgre sql without considering performance / tuning etc, by only focusing that syntax is right and query returns correct data

Language conversion and transformation related guidelines are really useful. I see couple of old vbscript examples (most of them not working for me) and could try to convert them to T4 templates.

I am surprised no one really needed this kind of conversion! I still don't have a right tool to do so.

Thanks in advance.

Have you seen this page:

Convert from other databases to PostgreSQL?