topic Python Script to update file geodatabase with sde database in Data Management Questions

Python Script to update file geodatabase with sde database

joshlay — Fri, 15 Feb 2013 14:30:55 GMT

I have a standalone file geodatabase that is on ArcServer and I want to update it weekly using our sde database. How do go about it using python script?

Thanks

Re: Python Script to update file geodatabase with sde database

LeoDonahue — Fri, 15 Feb 2013 14:43:09 GMT

you could start with using model builder and then export your model to a python script.

in data management tools (toolbox):
under workspace is the tool for creating a FGDB.
under general is the tool for deleting featureclasses
under feature class is the tool for creating a new featureclass

Re: Python Script to update file geodatabase with sde database

AnthonyGiles — Fri, 15 Feb 2013 14:44:03 GMT

You can create a replica from your sde database to your file geodabase:

http://resources.arcgis.com/en/help/main/10.1/index.html#/Creating_a_one_way_or_two_way_replica/003n000000tm000000/

Then set up a model using the synchronize changes tool under distributed databases. Turn this model into a Pyton script then use a windows scheduled task to run the script once a week

Regards

Anthony

Re: Python Script to update file geodatabase with sde database

MichaelVolz — Fri, 15 Feb 2013 14:53:24 GMT

The suggestion by Leo will work, but you will need to deal with the locks that are placed on a file geodatabase by ArcGIS Server.

I would suggest instead using the DeleteFeatures_management tool followed by the Append_management tool to avoid the locks.

You would have to stop the affected service of the file geodatabase if you want to delete the feature class and create it brand new each week. Then you would have to restart the service once the feature class creation has been completed.

Re: Python Script to update file geodatabase with sde database

joshlay — Fri, 15 Feb 2013 15:42:52 GMT

All,

Thanks for the speedy replies. I will try it out and let you all know if i have any problems.

Thanks.