I have a need to be able to "remove" Oracle from our application, and
instead use any RDBMS that supplies JDBC compliant drivers. Our
schema consists of 60 tables, 200 stored procedures, many sequences, a
few functions, stuff like that.
Are there any tools that help a developer to do this? I'm most
concerned with the stored procedures. Several of them are simple
inserts, deletes, updates yet they are written in proprietary Oracle
PL/SQL. I will have to convert those procedures and put them in Java,
right?
The more I think about this, I realize that there probably are not any
tools that exist to do this type of thing. I've searched the Internet
for several hours and have not found anything useful, yet. Anybody
have any comments on this?
Thanks, Steve