Pity, I thought it would be simple but in your case avoiding -skipfailures is obviously not enough.
Please use “reply to all” on this mailing list, otherwise mail does not reach the list. -Jukka Rahkonen- Lähettäjä: Hector muro <[email protected]> Lähetetty: maanantai 29. kesäkuuta 2020 17.28 Vastaanottaja: Rahkonen Jukka (MML) <[email protected]> Aihe: Re: [gdal-dev] MSSQLSpatial not using BCP to load Hi, Thanks for that. I removed the argument but the process still loads one-by-one and does not seem to use BCP... Regards Hector On Mon, 29 Jun 2020 at 15:10, jratike80 <[email protected]<mailto:[email protected]>> wrote: Hi, Don't use -skipfailures. It is only possible to skip errors one by one if transactions also contain just one row. It is even documented in the Performance hints in https://gdal.org/programs/ogr2ogr.html. -Jukka Rahkonen- hectormauer wrote > Hi, > > As a part of a project I need to load quite big geojsons into SQL Server > and I am using ogr2ogr to do so. > > Here is an example command I am using: > > ogr2ogr -f MSSQLSpatial > "MSSQL:server=xxx;database=xxx;UID=xxx;PWD=xxx;DRIVER={ODBC Driver 17 for > SQL Server}" -append --config SPATIAL_INDEX NO --config > MSSQLSPATIAL_USE_BCP TRUE --config MSSQLSPATIAL_BCP_SIZE 10000 --config > MSSQLSPATIAL_USE_GEOMETRY_COLUMNS NO -nln INM.nv_lv_ohline -nlt GEOMETRY > -t_srs EPSG:27700 -s_srs EPSG:4326 -skipfailures -splitlistfields > $DATA/data.json > > I found that it is very slow and I have been checking the SQL Server > profiler (as suggested already in this thread: > https://lists.osgeo.org/pipermail/gdal-dev/2018-May/048520.html) and I can > confirm that it is trying to insert every record one-by-one, hence the > slowness. > > What I can't get to understand is how to point gdal to my sql server > installation. > > SQL Server version: 2016 > GDAL: 3.0.4 > > Thanks and regards, > > Hector Muro > > _______________________________________________ > gdal-dev mailing list > [email protected]<mailto:[email protected]> > https://lists.osgeo.org/mailman/listinfo/gdal-dev -- Sent from: http://osgeo-org.1560.x6.nabble.com/GDAL-Dev-f3742093.html _______________________________________________ gdal-dev mailing list [email protected]<mailto:[email protected]> https://lists.osgeo.org/mailman/listinfo/gdal-dev
_______________________________________________ gdal-dev mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/gdal-dev
