10

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 Server to get shapefiles into SQL Server? What is the official method for importing this data?

The only references to this I've spotted on GIS.stackexchange are these questions: How to import shapefiles into MS SQL 2008 and then view that data using QGIS? and How to import shape file into SQL Server 2008 R2 using only SQL scripts? , which references spatial tools, GDAL etc. but nothing from Microsoft. Is there something I've missed? Call me naive but I'd almost expect there to be an option in the data source list in SQL Server Import/Export wizard for shapefile!

In summary: I'm not asking how to import shapefiles into SQL Server, I'm specifically asking how Microsoft expect us to import shapefiles into SQL Server.

closed as primarily opinion-based by PolyGeo Aug 4 '16 at 21:53

Many good questions generate some degree of opinion based on expert experience, but answers to this question will tend to be almost entirely based on opinions, rather than facts, references, or specific expertise. If this question can be reworded to fit the rules in the help center, please edit the question.

  • 2
    Why was this question closed? It's not opinion based. – Evan Carroll Jan 8 '17 at 20:09
  • Hmm, I would agree, perhaps could be reworded to be more along the lines of 'What tools does Microsoft provide to load spatial data into SQL Server' but that's not a million miles off what I did write.I don't know specifically what @PolyGeo believes is subjective. – Tumbledown Jan 9 '17 at 10:43
  • Only Microsoft can answer what they expect users to use. Everything else is an opinion. If someone from Microsoft wishes to provide an answer a flag on this question would enable it to be re-opened for that specific purpose. Alternatively, removing the references to Microsoft's expectations to focus the question on how to do the task you are stuck on, would make the question answerable by other than Microsoft. – PolyGeo Jan 9 '17 at 11:35
  • 1
    Happy to edit but it seems a little overly pedantic considering in the first paragraph I state 'What is the official method for importing this data?'. I'd argue this is synonymous with 'I'm specifically asking how Microsoft expect us to import shapefiles into SQL Server'. For instance, if I asked how Microsoft expect us to calculate the average in Excel, I'm fairly certain that an answer of 'use the average function that Microsoft provide' would be an objective one. I think it's fairly obvious that I'm not advocating we interview all Microsoft employees to see what their collective opinion is. – Tumbledown Jan 9 '17 at 11:55
11

I've been working with MS Sql Server Spatial since the '07 Katmai betas and I know of no Microsoft tool to do this. I had discussions with MS staff in '07 or '08 and at that point both reprojection and shapefile support were features they had chosen to leave up to third parties to implement.

  • 1
    I'm not certain of their reasoning but I do know from my own work on writing a shapefile reader that various tools have inconsistencies in how they write shapefiles, particularly attribute representation (including null values and padding) in the DBF file so perhaps they felt they could not reach a 100% success rate with all possible shapefiles from all possible sources. – Russell at ISC Sep 13 '13 at 16:58

Not the answer you're looking for? Browse other questions tagged or ask your own question.