From dbrunton@bigfootinteractive.com Wed Mar 28 18:19:06 2001 Received: from mail.bigfootinteractive.com (mx.bigfootinteractive.com [64.240.138.41]) by mail.postgresql.org (8.11.3/8.11.1) with ESMTP id f2SIJ6U45578 for ; Wed, 28 Mar 2001 13:19:06 -0500 (EST) (envelope-from dbrunton@bigfootinteractive.com) Received: from bigfootdoug (bigfoot-doug.office.bigfootinteractive.com [172.16.11.79]) by mail.bigfootinteractive.com (8.11.2/8.9.3) with SMTP id f2SITaB23607 for ; Wed, 28 Mar 2001 13:29:36 -0500 Message-ID: <01a201c0b7b4$48f90710$4f0b10ac@office.bigfootinteractive.com> From: "Douglas Brunton" To: Subject: Oracle -> Postgresql migration Date: Wed, 28 Mar 2001 13:24:11 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_019F_01C0B78A.60154370" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6700 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 X-Archive-Number: 200103/583 X-Sequence-Number: 2253 This is a multi-part message in MIME format. ------=_NextPart_000_019F_01C0B78A.60154370 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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 h= ave all of the tables ported over (with some minor datatype conversions). = The stored procedures are a different case altogether. I am wondering if a= nyone on the list has pointers/conversion utilities for undertaking this ta= sk. Any information is welcome. Douglas Brunton Technical Implementation Bigfoot Interactive dug@bigfootinteractive.com 646.227.7501 ------=_NextPart_000_019F_01C0B78A.60154370 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hello,
  I am currently in the process of at= tempting=20 an Oracle 8i to Postgresql 7.0.3 migration.  The table conversions wer= e=20 pretty straight forward, and I have all of the tables ported over (with som= e=20 minor datatype conversions).  The stored procedures are a different ca= se=20 altogether.  I am wondering if anyone on the list has pointers/convers= ion=20 utilities for undertaking this task.  Any information is=20 welcome.
 
Douglas Brunton
Technical=20 Implementation
Bigfoot Interactive
dug@bigfootinteractive.com646.227.7501
------=_NextPart_000_019F_01C0B78A.60154370-- From rmello@cc.usu.edu Wed Mar 28 18:51:11 2001 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?