[postgis-users] Any way to migrate Oracle Spatial tables to Postgis?

[Mateusz Loskot]

JOSE MORAN wrote:
> Hi guys,
> I'm searching any way to moving oracle spatial tables to Postgis..
> I thought Postgis have some tool to do this.. but nothing I have found..
> and not luck with documentation either
> 
> Please some help in this approach

Try to use ogr2ogr utility from GDAL/OGR (http://www.gdal.org/ogr/)

Basic command looks like as follows:


ogr2ogr -f PostgreSQL PG:dbname=mydb \
   OCI:sys/password at oracle_service


Here you will find more details about:

- OGR utilities

http://www.gdal.org/ogr/ogr_utilities.html

- PostgreSQL/PostGIS driver

http://www.gdal.org/ogr/drv_pg.html

- Oracle driver:

http://www.gdal.org/ogr/drv_oci.html



Cheers
-- 
Mateusz Loskot
http://mateusz.loskot.net