Re: Converting Oracle DDL to a standard

Every RDBMS has built ins that will exploit it in various ways, by creating generic code you will by necessity not be able to take advantage of all the functionality of the database, possibly at the cost of performance. This could be a wonderful chance to re-engineer your existing code and take advantage of all the options of the new platform instead of making it transportable. Java, for example, runs everywhere but often very slowly. C++ that has been compiled for the platform can usually outperform it easily.
"Steven Garcia" <stevengarcia_at_yahoo.com> wrote in message news:7f430eb1.0208052257.79622f59_at_posting.google.com...
> 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
Received on Tue Aug 06 2002 - 13:50:05 CEST