Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 727DE6503DA; Fri, 12 Dec 2008 15:59:09 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 43583-01; Fri, 12 Dec 2008 15:59:04 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from vms046pub.verizon.net (vms046pub.verizon.net [206.46.252.46]) by mail.postgresql.org (Postfix) with ESMTP id F067964FDF1; Fri, 12 Dec 2008 15:59:03 -0400 (AST) Received: from ridley.home ([173.67.13.101]) by vms046.mailsrvcs.net (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) with ESMTPA id <0KBS0021343LEH30@vms046.mailsrvcs.net>; Fri, 12 Dec 2008 13:42:58 -0600 (CST) Date: Fri, 12 Dec 2008 14:42:51 -0500 From: Robert Treat Subject: Re: [GENERAL] Tool to converter plsql in pgplsql In-reply-to: <937d27e10812120116p57c0836i35288aae9359cd7f@mail.gmail.com> To: pgsql-general@postgresql.org Cc: "Dave Page" , "Albe Laurenz" , "paulo matadr *EXTERN*" , admin Message-id: <200812121442.53674.xzilla@users.sourceforge.net> MIME-version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-transfer-encoding: 7bit Content-disposition: inline References: <346007.84275.qm@web52506.mail.re2.yahoo.com> <937d27e10812120116p57c0836i35288aae9359cd7f@mail.gmail.com> User-Agent: KMail/1.9.10 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200812/106 X-Sequence-Number: 30939 On Friday 12 December 2008 04:16:19 Dave Page wrote: > On Fri, Dec 12, 2008 at 7:12 AM, Albe Laurenz wrote: > > paulo matadr wrote: > >> you knowns a tool for automatic converter plsql in pgplsql? > >> this tool exist? > > > > EnterpriseDB claim that they can do something like this, > > but I don't believe that there is any tool which can do > > more than assist you. > > We don't have a converter, though we do have experience in this area > of course. Our Advanced Server product has direct support for pl/sql > however so you can run your code unmodified. > *In theory* :-) There are still a number of shortcomings, so depending on how large and/or complicated your systems are, it may or may not work for you, but it's certainly worth a look if you're planning a migration. -- Robert Treat Conjecture: http://www.xzilla.net Consulting: http://www.omniti.com