AnsweredAssumed Answered

How can I prune a Branch Versioned featureclass?

Question asked by kirkKuykendall on Oct 21, 2019
Latest reply on Oct 23, 2019 by kirkKuykendall

Update: I've posted an idea here: Support the D(elete) in CRUD for Branch Versioning 

Please upvote if you'd like this too.


Hi -


I have a branch versioned featureclass that has accumulated a good bit of history - there are multiple features with the same ObjectID. (GDB_Archive_ID is unique.)


How can I delete all but the most recent features, i.e., the ones having a maximum GDB_FROM_DATE for each unique ObjectID?


Update: this blog from 2 years ago says : 

Esri noted they are considering a prune task for a future release that would reduce the record counts in the base tables by combining older posted edits. 


After doing so, I would expect there to be no repeating ObjectIDs.  Currently all features have GDB_BRANCH_ID = 0.


I was expecting hoping to be able to do this with the Compress tool would do this. But it says:


This tool is not applicable for enterprise geodatabases that use branch versioning.

  Besides, I'd really like a tool that compresses prunes just the feature class (or table) and not the entire geodatabase.


Would I break anything if a ran an SQL script that deleted all but the most recent rows?


Thanks, Kirk