Re: Oracle to Postgresql conversion

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(dot)wheldon(at)prograsp(dot)com]
> Enviado el: miércoles, 19 de marzo de 2003 7:30
> Para: pgsql-general(at)postgresql(dot)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(at)pfaffenhofen(dot)de
> Bob(dot)Wheldon(at)gmx(dot)de
>
> Handy 0179/5061083
>
> Lantold Straße 1
> 85301 Schweitenkirchen
>
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>