Re: how to port Oracle database to PostgreSQL?

From: "Scott Marlowe" <smarlowe(at)qwest(dot)net>
To: "Vassilev, Lubomir G(dot)" <lyubomir(at)ou(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: how to port Oracle database to PostgreSQL?
Date: 2004-10-24 01:10:26
Message-ID: 1098580226.21035.117.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-10-24 01:38:15 Re: '1 year' = '360 days' ????
Previous Message Scott Marlowe 2004-10-24 01:08:44 Re: Log