[gdal-dev] ogr2ogr sqldump?

Kyle Shannon kyle at pobox.com
Sat Sep 27 10:48:37 PDT 2014


Vladan,

On Sat, Sep 27, 2014 at 9:45 AM, Vladan Divljak <ghostility at gmail.com> wrote:
> 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.

Have you looked at the pgdump driver for ogr:

http://gdal.org/drv_pgdump.html

It may suit your needs.

>
>
> Thanks,
> Vladan
>
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/gdal-dev



-- 
Kyle


More information about the gdal-dev mailing list