[gdal-dev] ogr2ogr sqldump?

[Tamas Szekeres]

This is something that can be fixed by binding the UTF8 strings as unicode
when passing to the ODBC driver. Going to provide a fix for this issue in
the MSSQL driver soon.

Best regards,

Tamas


2014-09-27 17:45 GMT+02:00 Vladan Divljak <ghostility at gmail.com>:

> 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
>
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/gdal-dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20140927/19718911/attachment.html>