AnsweredAssumed Answered

(Again) changes on the ArcGIS data are not reflected on the SQL data,

Question asked by geonetadmin on Jan 26, 2013
Latest reply on Feb 1, 2013 by geonetadmin
Original User: Jamal432@gmail.com

(Again) changes on the ArcGIS data are not reflected on the SQL data,


I�??ve posted this thread before but couldn�??t find a satisfactory solution.

All what I need  is to transfer the changes that occur on the arcgis data to the the sql data

I have been advised to do the following:

1. To reconcile and post between all parents and Childs

[ATTACH=CONFIG]21093[/ATTACH], [ATTACH=CONFIG]21094[/ATTACH]

2. To stop all editing and to disconnect all users

[ATTACH=CONFIG]21095[/ATTACH]

3. To apply the script below (attached)

[ATTACH=CONFIG]21096[/ATTACH]

------
# Name: GDBMaintenance.py
# Description: Rebuilds indexes and statistics
# on geodatabase feature classes
# using an existing .sde file.
# Author: Esri
# Import system modules
import arcpy, os
import sys, traceback
  
# set the workspace environment using the data owner account  D:\Practical2_Editing\Data\Sa_A.sde
path=arcpy.GetParameterAsText(0)
arcpy.env.workspace = path
                     ###########################################################

#Gather all the FeatureClasses and Tables from the Workspace
datasets = arcpy.ListTables() + arcpy.ListFeatureClasses()

#Save geodatabase path to use for concatonating feature dataset names
path = arcpy.env.workspace

#Determine if any were found
for fd in arcpy.arcpy.ListDatasets("","Feature"):
    arcpy.env.workspace = path + "\\" + fd
    #Gather the FeatureClasses from the Current Dataset
    datasets += arcpy.ListFeatureClasses()
arcpy.env.workspace = path
#Rebuild and analyze all datasets
arcpy.RebuildIndexes_management(arcpy.env.workspace,"NO_SYSTEM",datasets,"ALL")
print arcpy.GetMessages()

arcpy.AnalyzeDatasets_management(arcpy.env.workspace,"NO_SYSTEM",datasets,"ANALYZE_BASE","ANALYZE_DELTA","ANALYZE_ARCHIVE")
print arcpy.GetMessages()

#Rebuild and analyze all system tables and compress the Geodatabase
# set the workspace environment using the Geodatabase administrative account
arcpy.env.workspace = path
                      ######################################################

arcpy.RebuildIndexes_management(arcpy.env.workspace,"SYSTEM","","ALL")
print arcpy.GetMessages()
arcpy.AnalyzeDatasets_management(arcpy.env.workspace,"SYSTEM","","ANALYZE_BASE","ANALYZE_DELTA","ANALYZE_ARCHIVE")
print arcpy.GetMessages()
arcpy.Compress_management(arcpy.env.workspace)
print arcpy.GetMessages()

print "Processing complete"

-----------------------------------------------------
4. Unfortunately, it didn�??t work



What might be the issue?

Thank you

Best

Jamal

Outcomes