topic Re: Python Code to find all Versioned Feature Classes within Enterprise Geodatabase in Python Questions

Python Code to find all Versioned Feature Classes within Enterprise Geodatabase

BenVan_Kesteren1 — Sun, 08 Jul 2018 07:16:59 GMT

Hey Everyone,

I am wondering if anyone has got a simple script that they have that will iterate over all feature classes within my Enterprise Geodatabase, and return only the ones that are Registered as Versioned?

Sounds simple enough, I just haven't found an arcpy tool that will return versioned or not versioned.

Cheers

Re: Python Code to find all Versioned Feature Classes within Enterprise Geodatabase

DanPatterson_Retired — Sun, 08 Jul 2018 09:20:45 GMT

Ben, you might want to look through this thread.

The arcpy 'isversioned' is part of the 'describe' properties of a featureclass.

You need to cycle through the featureclasses and see if it meets the case

https://community.esri.com/message/782500-re-conditional-statement-unregisterasversioned?commentID=782500#comment-782500

Dataset properties....

isVersioned
(Read Only)
Indicates whether the dataset is versioned.
Boolean

Re: Python Code to find all Versioned Feature Classes within Enterprise Geodatabase

BenVan_Kesteren1 — Sun, 08 Jul 2018 13:02:41 GMT

Exactly what I am looking for, thanks Dan.

Re: Python Code to find all Versioned Feature Classes within Enterprise Geodatabase

BenVan_Kesteren1 — Sat, 11 Dec 2021 23:36:41 GMT

For anyone interested, below is the full code I used to do the following workflow:

find all datasets within enterprise sde
find only the datasets that have versioning applied
ignore the dataset if it contains the string 'vegetation'
unregister the dataset as being versioned

# set workspace
arcpy.env.workspace = r'Database Connections\GISADMIN@SDE_Spatial@SDE-DB.sde'

# build list of datasets
datasets = arcpy.ListDatasets()

#iterate over datasets
for dataset in datasets:
    # pull back information about the dataset
    description = arcpy.Describe(dataset)
    # ignore datasets that contain vegetation data
    if 'vegetation' not in dataset:
        # find if dataset is versioned
        if description.isVersioned:
            # unregister as versioned the dataset
            arcpy.UnregisterAsVersioned_management(in_dataset=dataset,
                                                   compress_default="COMPRESS_DEFAULT"
                                                   )‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Thanks again for your help Dan.