Addy dimri

Addy dimri

  • NA
  • 148
  • 7.9k

upload shape file in SQL

Aug 6 2022 5:54 AM

if i run the ogr2ogr command in cmd it shows:

C:\Program Files\GDAL>ogr2ogr -overwrite -f "MSSQLSpatial" "MSSQL:server=LAPTOP-4LSGSUIK\SQLEXPRESS;database=Geo;trusted_connection=yes" "C:\Program Files\GDAL\SpecialData\CH.shp" -progress -skipfailures -a_srs "EPSG:4326"
ERROR 1: INSERT command for new feature failed. [22003][Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error converting numeric to data type numeric.(8115), [01000][Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.(3621)
0...10...20...30...40...50...60...70...80...90...100 - done.
Warning 1: Failed to get extent for spatial index.