[postgis-users] Migration: From Oracle to PostgreSQL

[Zamil Murji]

Hello Alex,

We have been using an open source utility called Ora2Pg. It is very well written and easy to use. I could not find a way to migrate the spatial column from Oracle to Postgres directly. For our company this was not a problem, since we stored the lat and long in seperate columns anyways. I pulled everything once, and then ran an update script to create my geometry column and populate it. We had to slightly modify the Ora2Pg code so that a user without sys privileges could export from the Oracle table, but that was the only change we made to the core package. 

I hope this helps,
Zamil

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net]On Behalf Of Alex
Martins Daher
Sent: Thursday, May 13, 2004 10:34 AM
To: PostGIS Users Discussion
Subject: [postgis-users] Migration: From Oracle to PostgreSQL


Hi everyone!

Is there any tool so that I can migrate (spatial) data from an Oracle
database to PostgreSQL. Does pgadmin have any?

So, what is the easiest and less painful way to do this migration?

Regards,
Alex
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users