I have two ArcSDE databases, running with a two-way replica.One serves our interactive mapping website which gives certain users the ability to update, add points, edit attributes, etc. Then we have our master which is updated frequently by power users.
There are only a few feature classes that are currently being edited, and I would like to synchronize these updates ONLY if these feature classes have been edited.
I've developed a python script using the compare features tool, which compares the feature datasets with the master. I'd like to only synchronize changes from these three layers, update the master (so child to parent) and then have the master sync any new changes to the edit database (parent to child).
Is there any way to synchronize changes and schema for individual datasets or is there a better way to go about this?
import arcpy aburg_master_DBO_TownOwnedJan2013 = "Database Connections\\Connection to gisserver.sde\\aburg_master.DBO.Geocortex\\aburg_master.DBO.TownOwnedJan2013" Aburg_Edit_DBO_TownOwnedJan2013 = "Database Connections\\Connection to gisserver(2).sde\\Aburg_Edit.DBO.Geocortex\\Aburg_Edit.DBO.TownOwnedJan2013" compare_txt = "C:\\Test\\compare6.txt" # Process: Feature Compare result = arcpy.FeatureCompare_management(aburg_master_DBO_TownOwnedJan2013, Aburg_Edit_DBO_TownOwnedJan2013, "GlobalID", "ATTRIBUTES_ONLY", "IGNORE_M;IGNORE_Z", "0.001 Unknown", "0", "0", "", "OBJECTID;created_user;created_date;last_edited_user;last_edited_date", "NO_CONTINUE_COMPARE", compare_txt) changes = result.getOutput(1) print "Comparision Result is: " + changes change = str(changes) if change == 'false': print "LOL" else: print "Nope"