Friday, March 23, 2012
Thanks to the support of Digital Mapping Solutions, Nathan Woodrow and I have now added the new native MS SQL provider in the QGIS mainstream. The new provider now supports full featured read-write access to the MS SQL databases. By using the dragdrop support in the browser window you can easily push layers up to the database. The driver creates fully registered layers (by adding entries to the spatial_ref_sys and geometry_columns metadata tables) which are compatible with the GDAL MSSQL driver as well (to take advantage of the author being the same :-). In the heat of the work we have also enabled the dragdrop upload capability for the PostGIS provider.
We encourage you to give it a try and let us know if you find issues, by adding an entry to the QGIS issue tracker.