[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    RES: [postgis-users] Migration: From Oracle to PostgreSQL
From:       "Alex Martins Daher" <aldaher () cpqd ! com ! br>
Date:       2004-05-13 17:04:02
Message-ID: 7B3538F053C06142BF0AA9DF2D764AC60414EDE1 () MAILSRV1 ! aquarius ! cpqd ! com ! br
[Download RAW message or body]

Well, I think it will help a lot. Thank you, Zamil.

I'll give Ora2Pg a try, but what about pgAdmin Database Migration Wizard?
Have you ever used it?

-----Mensagem original-----
De: postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net]Em nome de Zamil
Murji
Enviada em: quinta-feira, 13 de maio de 2004 13:49
Para: PostGIS Users Discussion
Assunto: RE: [postgis-users] Migration: From Oracle to PostgreSQL


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@postgis.refractions.net
[mailto:postgis-users-bounces@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@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


[prev in list] [next in list] [prev in thread] [next in thread]