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"

Community♦

1

answered Sep 25 '12 at 7:48

R.K.

16.7k3 gold badges53 silver badges107 bronze badges

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

Which error did you get? – R.K. Sep 25 '12 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 '12 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 '12 at 9:14

add a comment |

1 Answer 1