how to port Oracle database to PostgreSQL?

my_lou · #1 (**permalink**) 10-20-04, 14:53

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.

eperich · #2 (**permalink**) 10-25-04, 07:41

there is a perlscript which converts the oracle tables to postgres
I think it's called ora2pg

the stored procedures you must rewrite

We had a migration of a oracle database to postgres
and all we changed is in the application "MINUS" to "EXCEPT"
very fast migration

karim2k · #3 (**permalink**) 10-30-04, 10:07

Quote:

Originally Posted by eperich

there is a perlscript which converts the oracle tables to postgres
I think it's called ora2pg

the stored procedures you must rewrite

We had a migration of a oracle database to postgres
and all we changed is in the application "MINUS" to "EXCEPT"
very fast migration

it's right here >>http://www.samse.fr/GPL/ora2pg/

Internet Services

Web Development

Digital Marketing

Consumer Tech