Branch Versioning Best Practices

256
2
08-02-2021 08:58 AM
Labels (3)
Brian_McLeer
Occasional Contributor II

We are starting to migrate our enterprise database from traditional to branch versioning. The recommended SDE admin workflow (link below) for traditional versioning is to delete \ create versions after editing is complete on a version. At our organization, we reconcile\post, delete versions, compress, rebuild indexes, analyze, create versions via nightly Python routines.

With migrating to branch versioning, compress is no longer needed, and you cannot rebuild indexes (indices?) on branch versioned data. 

My question for the community is it still necessary to delete\create branch versions on a daily schedule after an editor has completed edits for the day? Or is this becoming obsolete, such as compressing the database is as ESRI recommends migrating to branch versioning. 

 

https://desktop.arcgis.com/en/arcmap/10.3/manage-data/geodatabases/recommended-version-administratio...

Brian
0 Kudos
2 Replies
JoeBorgione
MVP Esteemed Contributor

We've done some testing with a cloud based enterprise gdb with branch versioning, and versions don't seem to play such a big role like traditional versioning.  We decided that versions can either stay or be deleted at the user's discretion.  My suggestion is you set up a test environment for yourselves and see if leaving them or deleting them has any impact either way on performance.

We think branch versioning rules while traditional versioning drools.... (Please feel free to quote me)

can't wait to retire....
StevenSalas
Occasional Contributor

@Brian_McLeer " you cannot rebuild indexes "  - it seems like that would be very important as more records accumulate in the table as edits occur.  Did you attempt this with the feature service stopped?  I would think if the service was still running there would be a lock (sorry, haven't tried it... just beginning to look at this new stuff).

0 Kudos