Vladan, On Sat, Sep 27, 2014 at 9:45 AM, Vladan Divljak <[email protected]> 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 > [email protected] > http://lists.osgeo.org/mailman/listinfo/gdal-dev -- Kyle _______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
