topic Re: To Version or Not To Version in Geodatabase Questions

To Version or Not To Version

JeffDavis7 — Tue, 11 Sep 2018 12:19:57 GMT

Hello,

I'd like to get some advice from the GeoNet Community.

Under what circumstances should you consider employing the use of versioning in your database structure?

Thank you.

Re: To Version or Not To Version

DanPatterson_Retired — Tue, 11 Sep 2018 12:30:15 GMT

1 If you have multiple users....

2 you don't want to have separate copies of your gdb

3 you need to accommodate different workflows

4 you do the webgis stuff

Overview of versioning—Geodatabases | ArcGIS Desktop

So for me, it is not relevant since I am on my own, I prefer separate copies, I am set in my ways and I don't do the web stuff

Re: To Version or Not To Version

JeffDavis7 — Tue, 11 Sep 2018 12:41:42 GMT

Thanks Dan. Made me laugh.

Aside from myself there is only one other person in our shop that will be editing. I don't see that changing. I have no problem with separate copies of the gdb. I am the administrator for ArcGIS Online and am the only one who will be publishing.

The previous administrator created versioning. I believe this was done because they expected more departments to participate but that did not happen. I just can't seem to see its necessity given our current state.

Re: To Version or Not To Version

KevinDunlop — Tue, 11 Sep 2018 13:27:32 GMT

Another reason is if you want to do What If cases. For example if you are planning out a new layout for a park or shopping center, you can created multiple versions for each proposed layout. Since they are independent of each other until you reconcile and post, you can keep each layout as its own version. Once the decision makers choose an option, you can post that version and delete the rest.

In addition, the edit undo and redo tools use a version environment to work. Otherwise any changes are posted to the base table once they are made.

Re: To Version or Not To Version

JeffDavis7 — Tue, 11 Sep 2018 16:22:19 GMT

Dan,

Do you follow a typical database design structure?

Re: To Version or Not To Version

DanPatterson_Retired — Tue, 11 Sep 2018 16:41:17 GMT

Most of my work uses gdbs to store results. I have rarely had the need to get into this type of scenario...

Fields, domains, and subtypes—Geodatabases | ArcGIS Desktop

The end use of your data should control your workflow.

Re: To Version or Not To Version

PeterKing — Tue, 11 Sep 2018 19:33:59 GMT

Not sure about your environment but another consideration is performance. Unversioned data is much faster as there are fewer "other" tables for the DB Engines to sort through.