Use Python scripting to batch reconcile and post versions - set the workspace

04-23-2020 01:04 PM
Occasional Contributor

Hi - i'm fairly new to python, but am working my way through this article Use Python scripting to batch reconcile and post versions—ArcGIS Help | ArcGIS Desktop  .  I am on the step "Rebuild indexes and update statistics" and I have to set the workspace environment.  

# set the workspace

arcpy.env.workspace = "C:\\Projects\\MyProject\\user1.sde"

Where do i find the path like listed above for the gdb Owner?  I have enterprise gdbs set up and there is one user who is the db owner.  Is this just the sde connection file location?  Or can i chose any folder location? 





0 Kudos
3 Replies
MVP Esteemed Contributor

You'll need a connection file with the owner creds to do that; depending on how you set up your enterprise (sde) the SDE user is the guy that does that operation as I recall.

That should just about do it....
Occasional Contributor II

here is one i use. Reconcile Versions—Data Management toolbox | Documentation 

# Set workspace
arcpy.env.workspace = r'C:\Users\####\AppData\Roaming\ESRI\Desktop10.6\ArcCatalog\Connection to ####.sde'

# Set the workspace environment
workspace = arcpy.env.workspace

# Use a list comprehension to get a list of version names where the owner
# is the current user and make sure sde.default is not selected.
#verList = [ for ver in arcpy.da.ListVersions() if ver.isOwner
          # == True and != '####']

print ('Reconciling Complete')‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍
MVP Regular Contributor

You can build the connection on the fly in your code if you like. But it is simplest to just create one ahead of time as Joe suggested. 

The python way:

Create Database Connection—Help | ArcGIS for Desktop 

Or in ArcCatalog:

- right-click on a folder and select New > Database Connection...

- then you will need the user name and password etc.

0 Kudos