Thread: how to port Oracle database to PostgreSQL?

how to port Oracle database to PostgreSQL?

From
"Vassilev, Lubomir G."
Date:

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.

Re: how to port Oracle database to PostgreSQL?

From
"Scott Marlowe"
Date:
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.