Received: from fslc.ser.usu.edu (fslc.ser.usu.edu [129.123.28.122]) by mail.postgresql.org (8.11.3/8.11.1) with ESMTP id f2SIpBU51076 for ; Wed, 28 Mar 2001 13:51:11 -0500 (EST) (envelope-from rmello@fslc.usu.edu) Received: (from rmello@localhost) by fslc.ser.usu.edu (8.11.3/8.11.3/Debian 8.11.2-1) id f2SIp5t24274; Wed, 28 Mar 2001 11:51:05 -0700 Date: Wed, 28 Mar 2001 11:51:05 -0700 From: Roberto Mello To: Douglas Brunton Cc: pgsql-sql@postgresql.org Subject: Re: Oracle -> Postgresql migration Message-ID: <20010328115105.A24219@cc.usu.edu> References: <01a201c0b7b4$48f90710$4f0b10ac@office.bigfootinteractive.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.3.15i In-Reply-To: <01a201c0b7b4$48f90710$4f0b10ac@office.bigfootinteractive.com>; from dbrunton@bigfootinteractive.com on Wed, Mar 28, 2001 at 01:24:11PM -0500 X-Archive-Number: 200103/584 X-Sequence-Number: 2254 On Wed, Mar 28, 2001 at 01:24:11PM -0500, Douglas Brunton wrote: > Hello, > I am currently in the process of attempting an Oracle 8i to Postgresql 7.0.3 migration. The table conversions were pretty straight forward, and I have all of the tables ported over (with some minor datatype conversions). The stored procedures are a different case altogether. I am wondering if anyone on the list has pointers/conversion utilities for undertaking this task. Any information is welcome. I wrote a "Porting from Oracle PL/SQL" document that was added to the PL/pgSQL documentation in 7.1. It has lots of useful info on how to port to PL/pgSQL. You can find this document under the Programmer's manual on the PG 7.1 documentation (development docs). This week I will change that document to become more generic and add information on how to change some Oracle'isms (e.g. nvl, decode, etc.) to PostgreSQL, sticking to the standard where possible. -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, Web Developer Backup not found: (Q)uem mandou usar o Stacker?