This has come up a few times now. Multiple questions deserve at least one answer, right?
First, Microsoft has not produced a shapefile loader (or exporter). If this is important to you, here’s the Connect item to hit. (And yes: we do listen to Connect!)
So, what are you to do? There are a few options:
Hopefully one of these solutions will work for you.
Not sure it helps much - but we've started a new section on our site covering SQL Server 2008 Spatial (hopefully all the information is accurate). We are still green ourselves as far as 2008 goes so we may have made some errors.
For Part 1 and Part 2 - we cover installing express, using Morten's tool to load shape and also doing transform with OGR. We'll need to check out some of the other tools you mentioned at a later time to see what gems they offer.
Absolutely! Thanks for pointing this out. I saw your tutorial---and it looked very useful---but it slipped my mind when I was putting this post together.
We built our own. It's fairly simple. The only snag I've hit so far was that the ADO.Net DBase provider does not exist in the 64bit world, so I had to build my app for x86. This is going to be a problem, unless you can push all your DBF data into another database. Or, as in our case, we're not too fussed about 64bit at this moment in time and will run about panicking when x64 is old and x86 code ceases to run.
ISC has just released the Public Beta of MapDotNet UX which has a number of features that integrate with SQL Server 2008. One of the biggest components of the product is MapDotNet UX Studio, which is a FREE, WPF application that allows users to import GIS data to SQL 08 from the Shapefiles, ArcSDE, and PostGIS data sources.
Register, download and use MapDotNet UX Studio(for Free!):
Can you explain the half-hemispher limitation on the geographical datatype? Reading various posts recently, I suspect that it is to do with determining what is the inside and what is the outside of a region, but apparently this can be signalled by the ring orientation of the polygon. What is the timeline for introducing whole sphere support? Will this be in a service pack or will we have to wait for the next major upgrade?
You can also use the Open Source SharpMap.Demo.FormatConverter project in the trunk of SharpMap V2 - currently in development at http://sharpmapv2.googlecode.com .
The project SharpMap.Demo.MapViewer can also display data from a variety of sources including Sql Server 2008