2

I have a web mapping service created on ESRI infrastructure (ArcGIS Server (WFS and WMS) with editable data from SQL Server Spatial. I am trying to switch from ArcGIS to Geoserver. I have published the layers from QGIS using GeoServer Explorer Plugin. But all the SQL Server Spatial tables are getting converted to shapefiles. The plugin allows to connect to PostGIS as in the linked page, but currently all my data is on SQL Server db and heavily related to quite a many attribute tables. Also since the web application has the editing workflow, so publishing static shapefile won't work for me. Is the way to publish views from SQL Server spatial to GeoServer is to publish views from PostGRE linked to SQL server? Are there any fallback for the approach - performance etc.? I am open to experiment with any other open source product if there is any setback for this approach.

1

First you need to install the SQL Server Plugin and then you follow the normal procedure for displaying database views in GeoServer.

I'm not sure if adding the plugin will enable sharing from QGIS or not, if you have Boundless support I'm sure they can tell you, otherwise feel free to experiment and report back here.

  • I installed the plugin and published the map service - I have not got warning (unlike last time getting converted to shapefile). It published successfully. But my attribute change in SQL Server did not reflect on map service - (checked for caching etc.). I can see the change in QGIS project. – Deep Mar 10 '16 at 21:25
  • I have posted another question related to geoserver (gis.stackexchange.com/questions/184543/…). – Deep Mar 11 '16 at 16:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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