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 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
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
Show quoted text
-----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: AltaHallo 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.deHandy 0179/5061083
Lantold Straße 1
85301 Schweitenkirchen---------------------------(end of
broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
Import Notes
Resolved by subject fallback