Re:Amazon’s Consumer Business Turned Off Final Oracle Database
by samfriedman on Tuesday October 15, 2019 @11:23AM
(#21259411)
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?
[ Parent
| on HN ]
Re:Amazon’s Consumer Business Turned Off Final Oracle Database
by metadata on Tuesday October 15, 2019 @11:40AM
(#21259636)
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.
Re:Amazon’s Consumer Business Turned Off Final Oracle Database
by holykin on Tuesday October 15, 2019 @12:54PM
(#21260661)
When is it out of Beta?
Re:Amazon’s Consumer Business Turned Off Final Oracle Database
by metadata on Wednesday October 16, 2019 @10:40AM
(#21270843)
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.
Re:Amazon’s Consumer Business Turned Off Final Oracle Database
by dragonwriter on Tuesday October 15, 2019 @11:41AM
(#21259646)
> 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.