How to save a vector layer from QGIS to Sql Server 2008 or 2012?

Question

using QGIS, i've loaded up some administrative boundary data of New Zealand. I wish to now import this vector data from QGIS into my Sql Server 2012.

Is there any way to do this with QGIS 1.8.0-Lisboa?

Community · Accepted Answer · 2017-04-13 12:34:05Z

3

I don't know if you can do it directly with QGIS but Shape2SQL ( free standalone tool ) can do it for you.

enter image description here

ogr2ogr -overwrite -f MSSQLSpatial "MSSQL:server=.\MSSQLSERVER2008;database=spatial;trusted_connection=yes" "your_shapefile.shp"

CommunityBot

1

answered Sep 25, 2012 at 7:48

R.K.

17.2k3 gold badges58 silver badges109 bronze badges

I've tried that (so many times) but it failed (with the administrative dataset from that link).
– Pure.Krome
Sep 25, 2012 at 7:49
1

Which error did you get?
– R.K.
Sep 25, 2012 at 7:52
exe crashed. yep -> stack trace, dump, etc. I might try the ogr2ogr method. Where can i find it? (i've installed QGIS, remember). Assumption : it's included with the stock standard QGIS 1.8 windows install.
– Pure.Krome
Sep 25, 2012 at 9:10
You can try adding the GDAL directory to your Windows path. Once you've done that, you can invoke the command on the command prompt (cmd.exe)
– R.K.
Sep 25, 2012 at 9:14

Add a comment |

1 Answer 1