http://planet.qgis.org/planet/tag/ogr2ogr/
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi6OCRC_hizCuvUIELjJf5nfJzNQaiMmMuO6zUZbxhV8wzqgeeFLwMSiW4L1PPBGjQEbocnsjb5JH2MZ8NTJmTpP2DEKGY4JmeaqhenE6z3wMsUSas80XdSiOXYSPLWL8qP5HkJXJyvLH0/s640/ss+%25282019-10-07+at+10.17.48%2529.png)
下載轉檔程式:
release-1900-x64-gdal-3-0-0-mapserver-7-4-0
執行:SDKShell.bat
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi_wj-wTikOB0uAtfCGUiP7Qme25XoZOvcQk4NmZAowCLGJ6IDjsXFPDoioTPTbwxe0gI0e5oHtoTgYHAsk-elIS1RBWS74fgc8jTidmi-4Plg0EWkVSQjQKM_OurRTZUEDigLHKufkxV0/s640/ss+%25282019-10-07+at+04.15.04%2529.png)
再依照下面的指令,產出要的shp,修改「紅色字」部分。
https://gdal.org/drivers/vector/mssqlspatial.html
ogr2ogr -f "ESRI Shapefile" "C:\temp\sqlexport.shp"
"MSSQL:server=localhost\sqlexpress;database=tempdb;trusted_connection=yes;ID=sa;Password=*gis5200"
-sql "SELECT * FROM OGRExportTestTable"
沒有留言:
張貼留言