topic Re: Compression on an sde DB in Data Management Questions

Compression on an sde DB

BrianBorg1 — Thu, 16 Apr 2015 17:36:34 GMT

Is it in any way possible to successfully perform a compression on an sde db which needs to be on-line 24/7? Seems like compression is only successful after disconnecting all user connections and halting all ArcGis server web services and operations.

Re: Compression on an sde DB

JakeSkinner — Thu, 16 Apr 2015 17:55:26 GMT

Hi Brian,

If ArcGIS Server services cannot be stopped and are the reason you cannot disconnect users, you may want to consider replicating your data to a File Geodatabase, that is, all data that is not needed for an editable Feature Service.

The benefits of this workflow is that File Geodatabases generally perform faster, and your services (which may be external) are not accessing your enterprise geodatabase.

You could schedule scripts to synchronize the changes of your enterprise geodatabase to your File Geodatabase, as well as compress your geodatabase.

Re: Compression on an sde DB

BrianBorg1 — Thu, 16 Apr 2015 18:24:10 GMT

Hi Thanks for your feedback. Unfortunately the data cannot be replicated as the current DB has been set with the option to move edits to base. Perhaps the easiest way out is to create a new DB with the possibility of replication and transfer all data.

Re: Compression on an sde DB

JoeBorgione — Thu, 16 Apr 2015 18:42:55 GMT

I do exactly what Jake describes: replicate (one way) from SDE to a FGDB. Works really slick. Are you sure you can't do a one-way replica from your DB with it set to move edits to base? I don't know for sure either way as my SDE is versioned with out that option.

Re: Compression on an sde DB

EmadAl-Mousa — Fri, 17 Apr 2015 05:30:02 GMT

you can perform compression while there services connecting to your geodatabase, however it won't be the "optimal compression".

in any IT environments, you need to have a "block time" period where you can perform your upgrades,maintenance,...etc activities and this will require shutdown of your services.

Also, it depends how frequently you need to perform the compression operation, depending if you have heavy editing on your data (weekly,monthly,...etc).

what jack is proposing is a good option, also you can do replication between 2 enterprise geodatabase if you have the resources, and have active/active map services architecture for the continuation of your services.