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.
[GIS] How to publish SQL Server Spatial views to GeoServer
geoserverpublishingqgissql-server-spatial
Best Answer
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.