[Qgis-user] Export to SQL Server plugin

[Rikesh Lad]

Hello,

I am having an issue loading either a postgis layer or sql server layer
into a sql server database using the Export to SQL Server plugin. I have
attached the two error log files. My QGIS version is 3.28.0-Firenze.

Rikesh
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20221130/93137ce0/attachment.htm>
-------------- next part --------------
QGIS version: 3.28.0-Firenze
QGIS code revision: ed3ad0430f3
Qt version: 5.15.3
Python version: 3.9.5
GDAL version: 3.5.2
GEOS version: 3.10.3-CAPI-1.16.1
PROJ version: Rel. 9.1.0, September 1st, 2022
PDAL version: 2.4.3 (git-version: 434757)
Algorithm started at: 2022-11-30T12:05:50
Algorithm 'Export to SQL Server (new connection)' starting…
Input parameters:
{ 'ADDFIELDS' : False, 'APPEND' : False, 'A_SRS' : None, 'CLIP' : False, 'DATABASE' : '', 'DIM' : 0, 'DRIVER' : 'ODBC Driver 17 for SQL Server', 'FIELDS' : [], 'GEOCOLUMN' : 'geom', 'GT' : '', 'GTYPE' : 0, 'INDEX' : False, 'INPUT' : 'postgres://dbname=\'test\' host=localhost port=5432 user=\'postgres\' password=\'1234\' sslmode=disable key=\'id\' srid=4326 type=Polygon checkPrimaryKeyUnicity=\'1\' table="client"."client1" (geom)', 'LAUNDER' : False, 'MSSQLSPATIAL_USE_BCP' : False, 'MSSQLSPATIAL_USE_GEOMETRY_COLUMNS' : True, 'OPTIONS' : '', 'OVERWRITE' : False, 'PASSWORD' : '', 'PK' : 'id', 'PRECISION' : True, 'PRIMARY_KEY' : '', 'PROMOTETOMULTI' : True, 'SCHEMA' : '', 'SEGMENTIZE' : '', 'SERVER' : '', 'SHAPE_ENCODING' : '', 'SIMPLIFY' : '', 'SKIPFAILURES' : False, 'SPAT' : None, 'S_SRS' : None, 'TABLE' : '', 'T_SRS' : None, 'USER' : '', 'WHERE' : '' }

GDAL command:
cmd.exe /C ogr2ogr.exe -progress -f MSSQLSpatial "MSSQL:driver={ODBC Driver 17 for SQL Server};" -lco DIM=2 "PG:dbname='test' host=localhost port=5432 user='postgres' password='1234' sslmode=disable" client.client1 -lco GEOMETRY_NAME=geom -lco FID=id -nln client.client1 -nlt PROMOTE_TO_MULTI --config MSSQLSPATIAL_USE_BCP NO
GDAL command output:
ERROR 1: Unable to find driver `MSSQLSpatial'.
Process returned error code 1
Execution completed in 0.18 seconds
Results:
{}

Loading resulting layers
Algorithm 'Export to SQL Server (new connection)' finished
-------------- next part --------------
QGIS version: 3.28.0-Firenze
QGIS code revision: ed3ad0430f3
Qt version: 5.15.3
Python version: 3.9.5
GDAL version: 3.5.2
GEOS version: 3.10.3-CAPI-1.16.1
PROJ version: Rel. 9.1.0, September 1st, 2022
PDAL version: 2.4.3 (git-version: 434757)
Algorithm started at: 2022-11-30T12:06:39
Algorithm 'Export to SQL Server (new connection)' starting…
Input parameters:
{ 'ADDFIELDS' : False, 'APPEND' : False, 'A_SRS' : None, 'CLIP' : False, 'DATABASE' : '', 'DIM' : 0, 'DRIVER' : 'ODBC Driver 17 for SQL Server', 'FIELDS' : [], 'GEOCOLUMN' : 'geom', 'GT' : '', 'GTYPE' : 0, 'INDEX' : False, 'INPUT' : 'mssql://dbname=\'test\' host=localhost\\mssqlserver01 estimatedmetadata=true srid=4326 type=MultiPolygon disableInvalidGeometryHandling=\'0\' extentInGeometryColumns=\'0\' table="dbo"."test1" (geom)', 'LAUNDER' : False, 'MSSQLSPATIAL_USE_BCP' : False, 'MSSQLSPATIAL_USE_GEOMETRY_COLUMNS' : True, 'OPTIONS' : '', 'OVERWRITE' : False, 'PASSWORD' : '', 'PK' : 'id', 'PRECISION' : True, 'PRIMARY_KEY' : '', 'PROMOTETOMULTI' : True, 'SCHEMA' : '', 'SEGMENTIZE' : '', 'SERVER' : '', 'SHAPE_ENCODING' : '', 'SIMPLIFY' : '', 'SKIPFAILURES' : False, 'SPAT' : None, 'S_SRS' : None, 'TABLE' : '', 'T_SRS' : None, 'USER' : '', 'WHERE' : '' }

GDAL command:
cmd.exe /C ogr2ogr.exe -progress -f MSSQLSpatial "MSSQL:driver={ODBC Driver 17 for SQL Server};" -lco DIM=2 MSSQL:database=test;server=localhost\mssqlserver01;trusted_connection=yes;tables=test1 dbo.test1 -lco GEOMETRY_NAME=geom -lco FID=id -nln dbo.test1 -nlt PROMOTE_TO_MULTI --config MSSQLSPATIAL_USE_BCP NO
GDAL command output:
FAILURE: 
Unable to open datasource `MSSQL:database=test;server=localhost\mssqlserver01;trusted_connection=yes;tables=test1' with the following drivers.
-> `PCIDSK' 
-> `netCDF' 
-> `PDS4' 
-> `VICAR' 
-> `JP2ECW' 
-> `JP2OpenJPEG' 
-> `PDF' 
-> `MBTiles' 
-> `BAG' 
-> `EEDA' 
-> `OGCAPI' 
-> `ESRI Shapefile' 
-> `MapInfo File' 
-> `UK .NTF' 
-> `LVBAG' 
-> `OGR_SDTS' 
-> `S57' 
-> `DGN' 
-> `OGR_VRT' 
-> `Memory' 
-> `CSV' 
-> `NAS' 
-> `GML' 
-> `GPX' 
-> `LIBKML' 
-> `KML' 
-> `GeoJSON' 
-> `GeoJSONSeq' 
-> `ESRIJSON' 
-> `TopoJSON' 
-> `Interlis 1' 
-> `Interlis 2' 
-> `OGR_GMT'
-> `GPKG' 
-> `SQLite' 
-> `ODBC' 
-> `WAsP' 
-> `PGeo' 
-> `OGR_OGDI' 
-> `PostgreSQL' 
-> `MySQL' 
-> `OCI' 
-> `OpenFileGDB' 
-> `DXF' 
-> `CAD' 
-> `FlatGeobuf' 
-> `Geoconcept' 
-> `GeoRSS' 
-> `VFK' 
-> `PGDUMP' 
-> `OSM' 
-> `GPSBabel' 
-> `OGR_PDS' 
-> `WFS' 
-> `OAPIF' 
-> `SOSI' 
-> `EDIGEO' 
-> `SVG' 
-> `Idrisi' 
-> `XLS' 
-> `ODS' 
-> `XLSX' 
-> `Elasticsearch' 
-> `Carto' 
-> `AmigoCloud' 
-> `SXF' 
-> `Selafin' 
-> `JML' 
-> `PLSCENES' 
-> `CSW' 
-> `VDV' 
-> `GMLAS' 
-> `MVT' 
-> `NGW' 
-> `MapML'
-> `Parquet' 
-> `Arrow' 
-> `TIGER' 
-> `AVCBin' 
-> `AVCE00'
-> `HTTP'
Process returned error code 1
Execution completed in 0.11 seconds
Results:
{}

Loading resulting layers
Algorithm 'Export to SQL Server (new connection)' finished