5
votes
1answer
626 views

QGIS and SQL Server Spatial Tables Performance

I'm trying to get a SQL Server 2008 R2 spatial database up and running to streamline the production of maps using QGIS. Currently I just have a handful of spatial tables (a postcode level point table ...
1
vote
1answer
1k views

Importing shapefiles to SQL Server

I often use the brilliant SQL Server 2008 Spatial Tools to import shapefiles into SQL Server 2008. This works absolutely fine but it leaves me wondering, how do Microsoft expect end users of SQL ...
4
votes
2answers
673 views

How to preserve non-ASCII characters in ogr2ogr import?

I want to import a list of international place names and their locations into a SQL Server database using ogr2ogr. The source data is a CSV file encoded in UTF-8. I've prepared a five-record sample ...
2
votes
3answers
5k views

How to import shapefiles into MS SQL 2008 and then view that data using QGIS?

I'm a QGIS users but not a database person and I need some help on the DB side. I'm currently in the need to import several shape files into MSSQL 2008 and I have no clue how to do that and my IT guy ...
3
votes
2answers
217 views

What program(s) can I use to edit a boundary?

So i've got some shapefiles imported into my Sql Server 2008 Database. A number of these boundaries need to get 'cleaned up'. As such I need to do the following :- Export them from Sql Server 2008. ...