Hacker News Reader

Yep, we built SQL Tran to do exactly that. https://www.spectralcore.com/sqltran. Finishing the rewrite right now which allows us to make changes much faster.

When is it out of Beta?

In a few months, it's not so far away. If you can share your database code (data is not important), we can make sure that our parsers and translation layer work with all the code constructs you use from day 1.

> Are there any tools that do a decent job in translating procs to non-Oracle dialects?

One of the main selling points of EnterpriseDB (built on top of and supporting development of Postgres) is a significant degree of Oracle compatibility, including PL/SQL, client interfaces, etc., so if you go that route you might not need much translation.

I haven't used it in quite awhile but as I recall ora2pg[0] has some basic auto-conversion of PL-SQL.

[0] http://ora2pg.darold.net/

AWS has the AWS Schema Conversion tool that works pretty well.