ERROR 1: Error initializing the metadata tables :

by Benedek Simo   Last Updated October 15, 2018 13:22 PM

I use ogr2ogr (bundled with QGIS 2.14.3) on Windows to convert an ArcSDE MS SQL Server 2012 database with SQL Geometry to PostGIS (2.1.8). I use the following syntax:

ogr2ogr --config PGCLIENTCODING ISO-8859-2 -f "PostgreSQL" PG:"host=localhost user=postgres dbname=atlas password=secret" "MSSQL:server=srv-sql;database=test;trusted_connection=yes" -a_srs "EPSG:23700" -lco GEOMETRY_NAME=geom

It seems to do the conversion, all tables are copied, but I get this error:

ERROR 1: Error initializing the metadata tables :

From other post it seems that it is related to the MS SQL driver or the geometry_columns table, but I can't seem to find the problem as the error message does not continue...

Do I need to worry about this? Or how to get rid of this?

Related Questions

ogr2ogr with GDAL 2.4 not reprojecting correctly

Updated March 19, 2019 01:22 AM