Обсуждение: Porting Web application written in Oracle 8 PL/SQL to Postgresql
Porting Web application written in Oracle 8 PL/SQL to Postgresql
От
angelflow@yahoo.com (Andy)
Дата:
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
Re: Porting Web application written in Oracle 8 PL/SQL to Postgresql
От
domingo@dad-it.com (Domingo Alvarez Duarte)
Дата:
Look at http://www.openacs.org in openacs4 comunity.
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 informationtechnology josh@agliodbs.com and data management solutions (415) 565-7293 for law firms, small businesses fax 621-2533 and non-profit organizations. San Francisco
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.