If I store my vector GIS data in SQL-Server, what editors can I use to edit the GIS data?
Have you seen the SQL Spatial Tools from Sharp GIS? Or did you have more advanced requirements?
Manifold will directly read and write SQL Server spatial data. I assume you are using 2008, but if not, Manifold will also let you use SQL 2005 (Geometries are varbinary(MAX) not SQLGeometry / SQLGeography in that case). They have a free CLR add-in that provides spatial indexing for 2005.
It supports multi-users, conflict resolution, etc.
We use it internally and I know many others who do too. It's stable and robust.
The development build of GDAL includes an OGR driver for SQL Server:
Your open-source (free) alternatives are a bit limited, you might be able to put something together with GeoServer (http://docs.geoserver.org/stable/en/user/data/index.html) as a viewer at least, if a web app is your intent. However many commercial GIS environments support SQL Server; a list of 'spatial partners' can be found here
TatukGIS Editor will edit geospatial data in most all spatial databases - Sql Server, Oracle, SDE, PostGIS, pGeodb,etc.
Also, the new Fgis, based on tatukgis editor, can edit/view Sql Server Spatial. It is only $99. http://fgis.tatukgisconsulting.com/
I have used Manifold to edit SQL data, but it seems it actually grabs the table and brings the data into Manifold for edit (maybe stores it in memory?). When you save, it seems to write the whole table back to SQL.
I have used TatukGIS's Editor too. This does a very good job of just editing the selected records or writing the new records back to SQL. But I find the editing tools a little clunky.
I have also tried ArcGIS 10 via ArcSDE. Yes, you can tell ArcGIS to write the data as SQL Spatial format. But it wraps a lot of other tables around the data. PLUS, if you have a native SQL Spatial table, ArcGIS can not access it or edit it. It must run through Esri's GeoDatabase to be available to ArcGIS.
I would like to know if Quantum GIS built with the new OGR would allow for editing SQL Spatial. That would be a great solution.
To my opinion Manifold GIS is the most practicable solution for direct editing of SQL-Server geometries. Unfortunately they are now announcing a new Version for more than 18 months. So it is not really clear if you investment will be sustainable. But for the moment manifold is excellent.
if you want to do some coding mapdotnet.com offers read-write connectors to SQL-Server
MapInfo Professional has been able to read and write data stored in a SQL Server 2008 database. This support has been included in MapInfo Professional since v10.0.
No middleware required, except an extra table in the database describing to MapInfo Pro how to read the data and how to display the data on a map (styles and so)