Converting Between SQLServer, Oracle, PostgreSQL, MySQL, Sybase and others…

Hi all!
I was asked to make a conversion from T-SQL (MSSQL) Procedure to PL/PGSQL. Regarding how boring is this task, the follow link helped me:
http://www.sqlines.com/online

I highly recommend it. The site has a commercial solution to convert all database, but some code can be converted online for free. 🙂
The conversion not fixed at all, but make a good part of the work… And all help is helpful…

There are lots of differences that I had to adjust manually, like
– Temporary tables
– Column aliases
– String manipulating functions
– “nolock” clauses
– Data types review in general

Those links helped to map correct syntax:
http://pgdocptbr.sourceforge.net/pg80/plpgsql-mssql.html
http://www.postgresql.org/docs/9.5/static/functions-string.html
http://www.postgresql.org/docs/9.5/static/datatype.html

Good luck!
Matheus.

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.