Hi, I wonder how to speed up import to MSSQL. I have testing SQLite DB (~1GB) with 48 tables (overall number of records 11e6). I started with
$ ogr2ogr -f MSSQLSpatial MSSQL:... test.db It took more than 3hours! Tested on Windows computer with SQL Server 2012. I used SQL Server Native Client 11.0. So I tried to enable BCP (which should be enable anyway) and increased its size: $ ogr2ogr -f MSSQLSpatial MSSQL:... --config MSSQLSPATIAL_USE_BCP YES --config MSSQLSPATIAL_BCP_SIZE 10000 test.db No difference, more than 3 hours. Anything I could miss? It's my first experience with MSSQL. Anything related to configuration or so? Thanks for pointers in advance! Martin -- Martin Landa http://geo.fsv.cvut.cz/gwiki/Landa http://gismentors.cz/mentors/landa _______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/gdal-dev
