使用ogr2ogr将Shape file导入到SQL Server中

Posted on 2021-01-20 16:55 cnsnet 阅读(164) 评论(0) 编辑收藏举报

ogr2ogr -overwrite -progress -f "MSSQLSpatial" "MSSQL:server=[server address],[port];database=[database];UID=[user];PWD=[password];" "[shape file path]" -a_srs "EPSG:4326" -lco "GEOM_TYPE=geometry" -lco "GEOM_NAME=[geom column]" -lco UPLOAD_GEOM_FORMAT=wkt -nln "[sql table]"