Re: how to port Oracle database to PostgreSQL?

От:

"Scott Marlowe" <smarlowe@qwest.net>

Дата:

24 октября 2004 г. в 02:08:10

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.

how to port Oracle database to PostgreSQL?

От:

"Vassilev, Lubomir G." <lyubomir@ou.edu>

Дата:

23 октября 2004 г. в 23:15:29

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.