We build and maintain GIS data in a production environment with SDE on SQL 2008. We also have a need to open up WMS and WFS that will make a complete ESRI solution really expensive. With an ArcGIS Server Enterprise Advanced license, is it possible to replicate the data into a non-SDE postgis database and push deltas from the production environment?
2 Answers
You could use GeoServer to provide WMS/WFS direct from the SDE store. http://docs.codehaus.org/display/GEOTDOC/ArcSDE+DataStore
-
I haven't been able to find the *_sde.jar files for 10.0 Sorry, I didn't include that tidbit in the OP.– mfrancisFeb 16, 2011 at 19:11
-
-
You could use OGR2OGR to move data to Postgre/PostGIS and create WMS/WFS with f.i. UMN Mapserver or Geoserver.
-
Thanks... but that's a complete dump of a large dataset when edits have been made in the (frequently edited) production environment.– mfrancisFeb 16, 2011 at 19:00
-