[gdal-dev] ogr2ogr sqldump?

Vladan Divljak ghostility at gmail.com
Sat Sep 27 08:45:13 PDT 2014


Hi,

I want migrate data between PostGIS enabled Postgres database and SQL
Server spatial database. ogr2ogr seems like easiest possible way, but there
is a catch with this ticket: http://trac.osgeo.org/gdal/ticket/5239

I tried it nonetheless, but as expected Postgres tables with UTF-8 strings
show garbage in SQL Server.

I don't see any switch in org2ogr to be able to dump sql queries that
ogr2ogr executes in migration process. Is there any? That way I can
search/replace to get correct sql queries for the task.


Thanks,
Vladan
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20140927/2ed1415d/attachment.html>


More information about the gdal-dev mailing list