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?