Porting Web application written in Oracle 8 PL/SQL to Postgresql
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
Look at http://www.openacs.org in openacs4 comunity.
At 02:02 03/11/01 -0800, you wrote:
- Any auomated tools to translate the PL/SQL code & to create tables?
- What process do you recommend for doing the porting?
- Other suggestions?
Hello,
Try have a look at http://pgadmin.postgresql.org
It features a PL/pgSQL function editor with migration wizard (database only).
Best regards,
Jean-Michel POURE
Andy,
Please do NOT cross-post mail to 3 different lists in the future! It
shows a lack of respect for the other list subscribers.
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:
See Roberto Mello's PL/SQL porting guide at TechDocs:
http://techdocs.postgresql.org/
-Josh
______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh@agliodbs.com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco
Hi Andy,
I suggest you read the articles on:
http://techdocs.postgresql.org/
As there are some Oracle->PostgreSQL documents there.
Chris
Show quoted text
-----Original Message-----
From: pgsql-hackers-owner@postgresql.org
[mailto:pgsql-hackers-owner@postgresql.org]On Behalf Of Andy
Sent: Saturday, 3 November 2001 6:03 PM
To:
pgsql-hackers@postgresql.org.pgsql-general@postgresql.org.pgsql-sql@post
gresql.org
Subject: [HACKERS] Porting Web application written in Oracle 8 PL/SQL to
PostgresqlHi 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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
Just to complement Domingo's and Josh's good responses...
On Sat, Nov 03, 2001 at 02:02:45AM -0800, Andy wrote:
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:
Not a quick way. But there's a way :)
- Any auomated tools to translate the PL/SQL code & to create tables?
- What process do you recommend for doing the porting?
- Other suggestions?
As Domingo suggested, http://openacs.org/ is a pretty big web application
framework and applications built for Oracle and PostgreSQL. You can find
ideas in its data model of how to cope with the differences. It has
hundreds of PL/SQL (and PL/pgSQL) functions, and it's GPL'd.
The Porting Guide that Josh suggested is also included in the PostgreSQL
documentation, in the Programmer's Guide.
-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, Developer
You just watch yourself. I have the death sentence in twelve systems.