Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fA39nsq82804; Sat, 3 Nov 2001 04:49:54 -0500 (EST) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id fA3A2lE60488; Sat, 3 Nov 2001 05:02:47 -0500 (EST) (envelope-from news) From: angelflow@yahoo.com (Andy) X-Newsgroups: comp.databases.postgresql.sql, comp.databases.postgresql.questions, comp.databases.postgresql.general, comp.databases.postgresql.hackers Subject: Porting Web application written in Oracle 8 PL/SQL to Postgresql Date: 3 Nov 2001 02:02:45 -0800 Organization: http://groups.google.com/ Lines: 14 Message-ID: Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Complaints-To: groups-abuse@google.com To: pgsql-hackers@postgresql.org.pgsql-general@postgresql.org.pgsql-sql@postgresql.org X-Archive-Number: 200111/126 X-Sequence-Number: 17129 Hi all, 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: - Any auomated tools to translate the PL/SQL code & to create tables? - What process do you recommend for doing the porting? - Other suggestions? Thanks a lot. Andy