AnsweredAssumed Answered

Creating a weekly FGDB backup of an SDE

Question asked by PrillLake on Dec 20, 2014
Latest reply on Dec 31, 2014 by MLF

I need to create a script that will copy our county's parcel data, maintained in SDE/SQL, to a file geodatabase.  This script will be run as a scheduled task over the weekend.  What GP tool do you recommend for this process? Consider that our schema is 'set in stone' and we have no relationship classes to maintain.  I have tested both CopyFeatures_management and FeatureClassToFeatureClass_conversion.  Both work.  FC to FC is slightly faster, but speed is not really an issue.  In theory, CopyFeatures, run with Overwrite = True, matches our workflow as we are not converting to a shapefile or coverage.  FeatureClassToGeodatabase_conversion may be the best tool, as there are about 25 feature classes that need to be copied.


Also, I need to ensure that the machine running the script is able to connect to the SDE data.  We are using DBO-schema with OS authentication. The script will likely be run by the same server that houses our SDE.  Does anyone have experience with a similar scenario?


Thanks,  Adam