Re: how to port Oracle database to PostgreSQL? - Mailing list pgsql-general

From Vassilev, Lubomir G.
Subject Re: how to port Oracle database to PostgreSQL?
Date
Msg-id 2E392E1E4AF06D46B1720012FF4E207001924AF0@XMAIL1.sooner.net.ou.edu
Whole thread Raw
In response to how to port Oracle database to PostgreSQL?  ("Vassilev, Lubomir G." <lyubomir@ou.edu>)
Responses Re: how to port Oracle database to PostgreSQL?  (Oliver Elphick <olly@lfix.co.uk>)
List pgsql-general
Thanks for your reply, however as I am a total newbie around here, I've
no clue how to get to postgresql-x.y.z/contrib. I looked on the main
page but couldn't find it.

-----Original Message-----
From: Scott Marlowe [mailto:smarlowe@qwest.net]
Sent: Saturday, October 23, 2004 7:10 PM
To: Vassilev, Lubomir G.
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] how to port Oracle database to PostgreSQL?

On Wed, 2004-10-20 at 13:47, Vassilev, Lubomir G. wrote:
> ok, this is what's going on. i have this VB.NET application with
> Oracle 8.1.7 back end, but now i have to switch the whole thing to
> PostgreSQL. how do i do that? it's a big database, about 135 tables, a
> lot of views, triggers, a few stored procedures and functions. i
> understand there is some tool to do that.

There's a directory under postgresql-x.y.z/contrib called oracle that
has some helpful scripts.




pgsql-general by date:

Previous
From: nd02tsk@student.hig.se
Date:
Subject: PgSQL MVCC vs MySQL InnoDB
Next
From: "Philippe Lang"
Date:
Subject: Re: FKs and deadlocks