Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I need to implement a process for creating a file geodatabase copy (a read-only snapshot, essentially) of a production SDE geodatabase without using versioning, adding global ID columns, etc. I cannot change any aspect of the SDE geodatabase.

All of the documentation I have read on geodatabase replication says that the parent replica data must be versioned. Indeed, attempting to create a simple check-out replica with either the Create Replica wizard in ArcMap or the Create Replica geoprocessing tool fails with the following error message:

Can't create empty replica. Read only data or unversioned data cannot be replicated. Data versioned with the option to move edits to base cannot be replicated. GlobalIDs are required for two way and one way replica data. Creating one way archiving replica requires archiving to be enabled on the parent.

Is there a way around this?

I need to be able to run the process once a month so a scripted or programmatic solution would be preferred (arcpy, ArcObjects., etc.). The amount of data to be synchronized is large, probably 500 datasets/tables/feature classes.

One solution that comes to mind is exporting and importing ESRI XML Workspace documents, but this seems heavy-handed and error-prone. Another would be a more fine-grained approach of listing and copying individual datasets with arcpy or ArcObjects but if there is an easier, existing solution (i.e. geodatabase replication, if it would let me), that would be preferable.

share|improve this question
    
Certain you already have this knowledge but adding for question enhancement. Even though versioning is enabled in the replica scenario you don't HAVE to use anything other than default if you want. –  Brad Nesom Jun 13 '13 at 3:53
add comment

1 Answer 1

Replication would be the easiest, but you do have to register as versioned and you do have to use a global ID. Your only other options would be a model or python script, as you suspected. But the esri local government blog and gallery has recently mentioned an etl tool that is in beta. Look it up, it might help? http://gizinta.com/

share|improve this answer
    
That looks promising, I'll have to try it out. Thanks! –  blah238 Jun 13 '13 at 3:35
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.