4 ms·

In my mind the true "hard part" would be in migrating business logic that lives in Oracle stored procedures (PL-SQL). Are there any tools that do a decent job

In my mind the true "hard part" would be in migrating business logic that lives in Oracle stored procedures (PL-SQL). Are there any tools that do a decent job in translating procs to non-Oracle dialects?

mbell 7y ago
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/ http://ora2pg.darold.net/
metadata 7y ago
Yep, we built SQL Tran to do exactly that. https://www.spectralcore.com/sqltran https://www.spectralcore.com/sqltran. Finishing the rewrite right now which allows us to make changes much faster.
- holykin 7y ago
  When is it out of Beta?
  - metadata 7y ago
    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.
dragonwriter 7y ago
> 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.
poxrud 7y ago
AWS has the AWS Schema Conversion tool that works pretty well.