AnsweredAssumed Answered

SDE Management - Workflow

Question asked by kquinlan_CantonMA on Aug 21, 2018
Latest reply on Aug 22, 2018 by mvolz47

Hello, I am fairly new to SDE management and am looking for advice. We will be using Cityworks/Collector to have multiple departments edit GIS data. As a result, I have created a python script to automate the following steps:


1. Disconnect users/ Block Connections

2. Reconcile/ Post/ Delete Versions

3. Compress

4. Clear Workspace Cache

5. Recreate Versions

6. Accept Connections

7. Rebuild Indexes

8. Analyze Datasets


First, I welcome any critique on this workflow. -  I intend to run this after hours on a weekly basis.


Second, I am running into the issue where I am required to (re)register my database prior to republishing any MXDs due to recreating versions - but they all have the same name and permissions so I am at a loss.

We have two database connections and four versions:


What am I missing here? Thank you