Re: how to port Oracle database to PostgreSQL?

From: "Vassilev, Lubomir G(dot)" <lyubomir(at)ou(dot)edu>
To: "Scott Marlowe" <smarlowe(at)qwest(dot)net>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: how to port Oracle database to PostgreSQL?
Date: 2004-10-25 14:16:14
Message-ID: 2E392E1E4AF06D46B1720012FF4E207001924AF0@XMAIL1.sooner.net.ou.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)qwest(dot)net]
Sent: Saturday, October 23, 2004 7:10 PM
To: Vassilev, Lubomir G.
Cc: pgsql-general(at)postgresql(dot)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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ryan Richards 2004-10-25 14:19:31
Previous Message Tom Lane 2004-10-25 14:15:53 Re: FKs and deadlocks