pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Roberto Mello <rmello@cc.usu.edu>
To: Andy <angelflow@yahoo.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Porting Web application written in Oracle 8 PL/SQL to Postgresql
Date: Wed, 7 Nov 2001 06:57:45 -0700
Message-ID: <20011107065745.A18924@cc.usu.edu> (raw)
In-Reply-To: <adda1c82.0111030202.50a7bace@posting.google.com>
References: <adda1c82.0111030202.50a7bace@posting.google.com>

Just to complement Domingo's and Josh's good responses...

On Sat, Nov 03, 2001 at 02:02:45AM -0800, Andy wrote:
> 
> 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:

Not a quick way. But there's a way :)
 
> - Any auomated tools to translate the PL/SQL code & to create tables?
> - What process do you recommend for doing the porting?  
> - Other suggestions?

As Domingo suggested, http://openacs.org/ is a pretty big web application
framework and applications built for Oracle and PostgreSQL. You can find
ideas in its data model of how to cope with the differences. It has
hundreds of PL/SQL (and PL/pgSQL) functions, and it's GPL'd.

The Porting Guide that Josh suggested is also included in the PostgreSQL
documentation, in the Programmer's Guide.

-Roberto
-- 
+----| http://fslc.usu.edu USU Free Software & GNU/Linux Club |------+
  Roberto Mello - Computer Science, USU - http://www.brasileiro.net 
       http://www.sdl.usu.edu - Space Dynamics Lab, Developer    
You just watch yourself. I have the death sentence in twelve systems.



view thread (6+ messages)

Message-ID: <20011107065745.A18924@cc.usu.edu>
Permalink:  ../20011107065745.A18924@cc.usu.edu/
Also on:    postgresql.org/message-id/20011107065745.A18924@cc.usu.edu

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: rmello@cc.usu.edu, angelflow@yahoo.com
  Subject: Re: Porting Web application written in Oracle 8 PL/SQL to Postgresql
  In-Reply-To: <20011107065745.A18924@cc.usu.edu>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox