Thread: Porting Web application written in Oracle 8 PL/SQL to Postgresql

Hi all,

My company has a pretty big Web-based application written in PL/SQL
using an Oracle 8 backend database. We're thinking about moving from
Oracle to Postgresql. I wondered if there's any quick way to do the
porting:

- Any auomated tools to translate the PL/SQL code & to create tables?
- What process do you recommend for doing the porting?
- Other suggestions?

Thanks a lot.

Andy

Hi Andy,

I suggest you read the articles on:

http://techdocs.postgresql.org/

As there are some Oracle->PostgreSQL documents there.

Chris


> -----Original Message-----
> From: pgsql-hackers-owner@postgresql.org
> [mailto:pgsql-hackers-owner@postgresql.org]On Behalf Of Andy
> Sent: Saturday, 3 November 2001 6:03 PM
> To:
> pgsql-hackers@postgresql.org.pgsql-general@postgresql.org.pgsql-sql@post
> gresql.org
> Subject: [HACKERS] Porting Web application written in Oracle 8 PL/SQL to
> Postgresql
> 
> 
> Hi all,
> 
> My company has a pretty big Web-based application written in PL/SQL
> using an Oracle 8 backend database. We're thinking about moving from
> Oracle to Postgresql. I wondered if there's any quick way to do the
> porting:
> 
> - Any auomated tools to translate the PL/SQL code & to create tables?
> - What process do you recommend for doing the porting?  
> - Other suggestions?
> 
> Thanks a lot.
> 
> Andy
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>