Some tables from mdb not exported to PostGIS

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Some tables from mdb not exported to PostGIS

jjap
Greetings,
ogr2ogr has allowed me to successfully convert an ESRI personnal geodatabase from a Windows XP computer to an Ubuntu server 11.04 running PostGIS 1.5 with proper encoding . The tables containing the blob/shapefiles all made it but not the others. Am I right to presume I'll have to migrate those other tables by hand and rebuild references? 
Am I missing some options which would have allowed me to do it in one fell swoop? Any hints appreciated.
Reply | Threaded
Open this post in threaded view
|

Re: Some tables from mdb not exported to PostGIS

Eli Adam
Assuming that you are using ogr2ogr on the xp computer, you can fairly
easily setup ODBC connections for the non-spatial tables,
http://gdal.org/ogr/drv_odbc.html

Doing the same from linux is somewhat more difficult, the easiest path
I think to be http://gdal.org/ogr/drv_mdb.html

You can see some of my previous similar attempts,
http://lists.osgeo.org/pipermail/gdal-dev/2011-November/030833.html

And this general topic seems to be ongoing so which version you are
using may be relevant depending on specifics,
http://trac.osgeo.org/gdal/changeset/23931

Bests, Eli


On Fri, Jan 27, 2012 at 6:50 PM, jjap <[hidden email]> wrote:

> Greetings,
> ogr2ogr has allowed me to successfully convert an ESRI personnal geodatabase
> from a Windows XP computer to an Ubuntu server 11.04 running PostGIS 1.5
> with proper encoding . The tables containing the blob/shapefiles all made it
> but not the others. Am I right to presume I'll have to migrate those other
> tables by hand and rebuild references?
> Am I missing some options which would have allowed me to do it in one fell
> swoop? Any hints appreciated.
>
> --
> View this message in context: http://osgeo-org.1560.n6.nabble.com/Some-tables-from-mdb-not-exported-to-PostGIS-tp4344999p4344999.html
> Sent from the GDAL - Dev mailing list archive at Nabble.com.
> _______________________________________________
> gdal-dev mailing list
> [hidden email]
> http://lists.osgeo.org/mailman/listinfo/gdal-dev
_______________________________________________
gdal-dev mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/gdal-dev