New answers tagged mssql
Try adding: iface.mapCanvas().refresh() as last line.
I recommend you research Microsoft Sql Server Express because it supports Spatial data as a native datatype. ArcGIS supports read/write to Sql Server Express. You have the full power of T-SQL at your disposal, allowing you to mix and match Attribute queries with Spatial queries, join tables, create views, index data, backup data. The scripting in Sql Server ...
ogr2ogr -f MySQL MySQL:test,user=root MSSQLSpatial "MSSQL:server=.\MSSQLSERVER2008;database=geodb;trusted_connection=yes" See the documentation for the syntax http://www.gdal.org/ogr/drv_mysql.html
MSSQL server 2008 does not support spatial aggregation. BostonGIS provides a comparison between MSSQL Server 2008, PostGIS and mysql. In this comparison the following is said: Spatial Aggregates (functions like SUM but for spatial) Apparently none in this release so have to roll your own with CLR. There are numerous examples of this on the web. ...
Top 50 recent answers are included