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 2


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.
    – mfrancis
    Feb 16, 2011 at 19:11
  • I'm not an ESRI user but this might help old.nabble.com/…
    – Ian Turton
    Feb 16, 2011 at 19:30
  • Thanks, I had to order a developer kit data over support
    – mfrancis
    Feb 16, 2011 at 20:12

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.
    – mfrancis
    Feb 16, 2011 at 19:00
  • I think that will work... or at least get me closer.
    – mfrancis
    Feb 16, 2011 at 20:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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