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 Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s