Received: from brasileiro.net (slxwy.dorms.usu.edu [129.123.236.160]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fA7Dvim04287 for ; Wed, 7 Nov 2001 08:57:48 -0500 (EST) (envelope-from roberto@brasileiro.net) Received: from roberto by brasileiro.net with local (Exim 3.32 #1 (Debian)) id 161TD8-00057Q-00; Wed, 07 Nov 2001 06:57:46 -0700 Date: Wed, 7 Nov 2001 06:57:45 -0700 From: Roberto Mello To: Andy Cc: pgsql-sql@postgresql.org Subject: Re: Porting Web application written in Oracle 8 PL/SQL to Postgresql Message-ID: <20011107065745.A18924@cc.usu.edu> References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.3.23i X-Archive-Number: 200111/102 X-Sequence-Number: 5486 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.