Update: I've posted an idea here: Support the D(elete) in CRUD for Branch Versioning
Please upvote if you'd like this too.
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?