pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Porting Web application written in Oracle 8 PL/SQL to Postgresql
6+ messages / 6 participants
[nested] [flat]

* Porting Web application written in Oracle 8 PL/SQL to Postgresql
@ 2001-11-03 10:02  Andy <angelflow@yahoo.com>
  0 siblings, 5 replies; 6+ messages in thread

From: angelflow@yahoo.com @ 2001-11-03 10:02 UTC (permalink / raw)
  To: pgsql-hackers@postgresql.org.pgsql-general

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



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Porting Web application written in Oracle 8 PL/SQL to Postgresql
@ 2001-11-03 18:16  Domingo Alvarez Duarte <domingo@dad-it.com>
  parent: Andy <angelflow@yahoo.com>
  4 siblings, 0 replies; 6+ messages in thread

From: domingo@dad-it.com @ 2001-11-03 18:16 UTC (permalink / raw)
  To: pgsql-hackers@postgresql.org.pgsql-general

Look at http://www.openacs.org in openacs4 comunity.



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: [HACKERS] Porting Web application written in Oracle 8
@ 2001-11-05 15:35  Jean-Michel POURE <jm.poure@freesurf.fr>
  parent: Andy <angelflow@yahoo.com>
  4 siblings, 0 replies; 6+ messages in thread

From: Jean-Michel POURE @ 2001-11-05 15:35 UTC (permalink / raw)
  To: pgsql-general@postgresql.org

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



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Porting Web application written in Oracle 8 PL/SQL
@ 2001-11-05 16:49  Josh Berkus <josh@agliodbs.com>
  parent: Andy <angelflow@yahoo.com>
  4 siblings, 0 replies; 6+ messages in thread

From: Josh Berkus @ 2001-11-05 16:49 UTC (permalink / raw)
  To: angelflow@yahoo.com; pgsql-sql

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



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Porting Web application written in Oracle 8 PL/SQL to Postgresql
@ 2001-11-06 02:24  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
  parent: Andy <angelflow@yahoo.com>
  4 siblings, 0 replies; 6+ messages in thread

From: Christopher Kings-Lynne @ 2001-11-06 02:24 UTC (permalink / raw)
  To: Andy <angelflow@yahoo.com>; pgsql-hackers@postgresql.org

Hi Andy,

I suggest you read the articles on:

http://techdocs.postgresql.org/

As there are some Oracle->PostgreSQL documents there.

Chris


> -----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
> 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
> 
> ---------------------------(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
> 




^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Porting Web application written in Oracle 8 PL/SQL to Postgresql
@ 2001-11-07 13:57  Roberto Mello <rmello@cc.usu.edu>
  parent: Andy <angelflow@yahoo.com>
  4 siblings, 0 replies; 6+ messages in thread

From: Roberto Mello @ 2001-11-07 13:57 UTC (permalink / raw)
  To: Andy <angelflow@yahoo.com>; +Cc: pgsql-sql

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.



^ permalink  raw  reply  [nested|flat] 6+ messages in thread


end of thread, other threads:[~2001-11-07 13:57 UTC | newest]

Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-11-03 10:02 Porting Web application written in Oracle 8 PL/SQL to Postgresql Andy <angelflow@yahoo.com>
2001-11-03 18:16 ` Domingo Alvarez Duarte <domingo@dad-it.com>
2001-11-05 15:35 ` Re: [HACKERS] Porting Web application written in Oracle 8 Jean-Michel POURE <jm.poure@freesurf.fr>
2001-11-05 16:49 ` Re: Porting Web application written in Oracle 8 PL/SQL Josh Berkus <josh@agliodbs.com>
2001-11-06 02:24 ` Christopher Kings-Lynne <chriskl@familyhealth.com.au>
2001-11-07 13:57 ` Roberto Mello <rmello@cc.usu.edu>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox