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

[Milo van der Linden]

José,

You might consider using OGR from http://www.gdal.org/ogr/
with the ogr2ogr.exe commandline tool, you might be able to convert 
directly into postGIS from an Oracle DB.
You can download ogr as part of the fwtools at http://fwtools.maptools.org/

Formats describe that OGR has read/write support for both spatial 
databases. I do know the syntax to convert ESRI shape into postGIS:

ogr2ogr -overwrite -f "PostgreSQL" PG:"host=localhost user=gis_user 
dbname=gismain password=gis" -nln road "C:\mapdata\data\myRoads.shp"

when translating this to a direct conversion from Oracle spatial you 
will come to something like:

ogr2ogr -overwrite -f "PostgreSQL" PG:"host=localhost user=gis_user 
dbname=gismain password=gis" -nln road 
"OCI:userid/password at database_instance:table,table"

Unfortunately I haven't been able to test this, I have no OCI client and 
no Oracle Spatial DB available. But it should be possible!

Hope I have been of some assistance.



JOSE MORAN schreef:
> 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
>
> Saludos
> José
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>   


-- 


	

Milo van der Linden
skype: milovanderlinden <skype:milovanderlinden?add>
mlinden at zeelandnet.nl <mailto:mlinden at zeelandnet.nl>
milovanderlinden at gmail.com <mailto:milovanderlinden at gmail.com>
milo at 3dsite.nl <mailto:milo at 3dsite.nl>
http://www.3dsite.nl

	  	

De informatie in dit bericht reflecteert mijn persoonlijke mening en 
niet die van een bedrijf of instantie. Aan de informatie kunnen geen 
rechten worden ontleend. Indien dit bericht onderdeel is van een forum, 
mailing-list of community dan gelden automatisch de bij het betreffende 
medium behorende voorwaarden. The information in this message reflects 
my personal opinion and not that of a company or public body. All rights 
reserved.If this message is contained in a mailing-list or community, 
the rights on the medium are automatically adapted.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070829/7daa69da/attachment.html>