X-Original-To: pgsql-advocacy-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id CA7DCDA9C1 for ; Sat, 22 Oct 2005 20:01:51 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 18197-04 for ; Sat, 22 Oct 2005 23:01:48 +0000 (GMT) Received: from hub.org (hub.org [200.46.204.220]) by svr1.postgresql.org (Postfix) with ESMTP id EB92EDA97D for ; Sat, 22 Oct 2005 20:01:49 -0300 (ADT) Received: from localhost (av.hub.org [200.46.204.144]) by hub.org (Postfix) with ESMTP id 193E464B805 for ; Sat, 22 Oct 2005 20:01:54 -0300 (ADT) Received: from hub.org ([200.46.204.220]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 18184-06 for ; Sat, 22 Oct 2005 23:01:43 +0000 (GMT) Received: from ganymede.hub.org (blk-222-82-85.eastlink.ca [24.222.82.85]) by hub.org (Postfix) with ESMTP id 3D62564B802 for ; Sat, 22 Oct 2005 20:01:49 -0300 (ADT) Received: by ganymede.hub.org (Postfix, from userid 1000) id 85B8D38B99; Sat, 22 Oct 2005 20:01:52 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by ganymede.hub.org (Postfix) with ESMTP id 84E9F38736 for ; Sat, 22 Oct 2005 20:01:52 -0300 (ADT) X-Return-Path: X-Received: from ganymede.hub.org ([unix socket]) by ganymede.hub.org (Cyrus v2.2.12) with LMTPA; Fri, 21 Oct 2005 12:35:35 -0300 X-Sieve: CMU Sieve 2.2 X-Received: from localhost (localhost [127.0.0.1]) by ganymede.hub.org (Postfix) with ESMTP id 4C79746321 for ; Fri, 21 Oct 2005 12:35:35 -0300 (ADT) X-Received: from mail.postgresql.org [200.46.204.71] by localhost with IMAP (fetchmail-6.2.5.2) for scrappy@localhost (single-drop); Fri, 21 Oct 2005 12:35:35 -0300 (ADT) X-Received: from svr1.postgresql.org ([unix socket]) by svr1.postgresql.org (Cyrus v2.2.12) with LMTPA; Fri, 21 Oct 2005 12:33:52 -0300 X-Sieve: CMU Sieve 2.2 X-Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 5DA75DA81E for ; Fri, 21 Oct 2005 12:33:52 -0300 (ADT) X-Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 00500-10 for ; Fri, 21 Oct 2005 15:33:49 +0000 (GMT) X-Received: from nproxy.gmail.com (nproxy.gmail.com [64.233.182.206]) by svr1.postgresql.org (Postfix) with ESMTP id EF1C5DA79E for ; Fri, 21 Oct 2005 12:33:48 -0300 (ADT) X-Received: by nproxy.gmail.com with SMTP id q29so63300nfc for ; Fri, 21 Oct 2005 08:33:47 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=AovgS9ulQSdpRwCt4hqAeFzyEfVOnAUFMf84+9gYAiEfvVH5c3INmy+MWAwfuuDD018BRrvhaMRh5bpKz+P7A6Gag4ASL4w7gGw6PZiivdv9EniDxh6ryd9mZmw5HfBUvk+1RbAmogRNm3wDgFgpImZQEfgblzgP3HZNkrxbTB0= X-Received: by 10.49.5.4 with SMTP id h4mr218167nfi; Fri, 21 Oct 2005 08:33:47 -0700 (PDT) X-Received: by 10.48.239.10 with HTTP; Fri, 21 Oct 2005 08:33:47 -0700 (PDT) Message-ID: Date: Fri, 21 Oct 2005 16:33:47 +0100 From: Steve Woodcock To: psql-advocacy@postgresql.org Subject: OraToPG MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: by amavisd-new at hub.org ReSent-Date: Sat, 22 Oct 2005 20:01:47 -0300 (ADT) Resent-From: "Marc G. Fournier" Resent-To: pgsql-advocacy@postgresql.org ReSent-Subject: OraToPG ReSent-Message-ID: <20051022200147.G991@ganymede.hub.org> X-Virus-Scanned: by amavisd-new at hub.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.946 required=5 tests=[AWL=0.896, FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200510/311 X-Sequence-Number: 7946 I just came across OraToPG "a tool that helps to migrate Oracle databases to PostgreSQL. It focuses on SQL statements and, in particular, code written in Oracle's procedural language PL/SQL(TM)": http://rose.inf.unibz.it/~boehlen/cospa/index.html http://rose.inf.unibz.it/~boehlen/cospa/OraToPG/descr.html and there's a demo here: http://rose.inf.unibz.it/~boehlen/cospa/OraToPG/translate.cgi via a link from a Groklaw piece about Linux desktop migration: http://www.groklaw.net/article.php?story=3D2005102011342691 Looks pretty handy, should this be linked from the web site somewhere? Cheers, Steve Woodcock