Thread: Oracle to Postgresql conversion
Hallo All, Does anyone know how I can convert an application written with Oracle Portal (including Apache), Oracle packages, procedures,functions, etc. and PSP (a mixture of PL/SQL and HTML). One suggestion is that the new application could access PostgreSQL from within Apache using Java Servlet pages: if therewere any tools to convert the code, then that would be fine, but I expect there are not. PostgreSQL recommend PHP, but I think with Apache we must use the secondchoice, namely Java? Is there a chance of using a front-end, or is that an expensive solution? I have no worries about PL/SQL, because there are conversion utilitiesavailable! Regards, Bob Wheldon win@pfaffenhofen.de Bob.Wheldon@gmx.de Handy 0179/5061083 Lantold Straße 1 85301 Schweitenkirchen
Bob, there's a app (in contrib I think) named ora2pg. You can easily duplicate structures like tables, index, constraints,sequences, views... but you need to put your hands on every pl/sql procedure, function and package. -- Fernando O. Papa DBA > -----Mensaje original----- > De: Bob prograsp [mailto:bob.wheldon@prograsp.com] > Enviado el: miércoles, 19 de marzo de 2003 7:30 > Para: pgsql-general@postgresql.org > Asunto: [GENERAL] Oracle to Postgresql conversion > Importancia: Alta > > > Hallo All, > > Does anyone know how I can convert an application written > with Oracle Portal (including Apache), Oracle packages, > procedures, functions, etc. and PSP (a mixture of > PL/SQL and HTML). > > One suggestion is that the new application could access > PostgreSQL from within Apache using Java Servlet pages: if > there were any tools to convert the code, then > that would be fine, but I expect there are not. PostgreSQL > recommend PHP, but I think with Apache we must use the second > choice, namely Java? Is there a chance of > using a front-end, or is that an expensive solution? I have > no worries about PL/SQL, because there are conversion > utilities available! > > Regards, > > Bob Wheldon > win@pfaffenhofen.de > Bob.Wheldon@gmx.de > > Handy 0179/5061083 > > Lantold Straße 1 > 85301 Schweitenkirchen > > > > > ---------------------------(end of > broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster >
On Wed, 19 Mar 2003, Bob prograsp wrote: > Hallo All, > > Does anyone know how I can convert an application written with Oracle Portal (including Apache), Oracle packages, procedures,functions, etc. and PSP (a mixture of > PL/SQL and HTML). > > One suggestion is that the new application could access PostgreSQL from within Apache using Java Servlet pages: if therewere any tools to convert the code, then > that would be fine, but I expect there are not. PostgreSQL recommend PHP, but I think with Apache we must use the secondchoice, namely Java? Is there a chance of > using a front-end, or is that an expensive solution? I have no worries about PL/SQL, because there are conversion utilitiesavailable! If the app is written in Java already, then look at using JBoss, not apache. Apache in it's basic form doesn't do java. Tomcat the jsp engine by the apache team, can run underneath apache or can be used underneath JBoss. JBoss is the open source implementation of Sun's J2EE standard, and has gotten very good reviews from the folks who use it. http://www.jboss.org