Copy SDE Database to File Geodatabase

6832
4
05-09-2014 06:35 AM
ChrisCyphers
New Contributor
I'm using model builder and trying to copy a SDE database to a file geodatabase.  The SDE db has several feature datasets, feature classes, relationship classes and tables.  Each feature dataset within the db has feature classes, tables, & relationship classes.  I can�??t seem to find an easy way to copy everything from SDE to my personal DB.  This is a process that is going to be repeated weekly which is why I�??m creating a model.  I currently have a model that will do this but it�??s huge and cumbersome since I have to create each feature dataset, then copy each feature class, table & relation ship class, etc.  I was wondering how others are doing this.  I've tried the basic "copy" geoprocessing tool but it gives me errors when I do.  I've attached a pdf of my model so you can view what I've done.
Reply
0 Kudos
4 Replies
AsrujitSengupta
Regular Contributor III
Chris,

Maybe if you provide us with the error that you receive while trying to use the "Copy" tool, that would shed more light on your issue

I think the below two tools will do it for you:

Export XML Workspace Document (Data Management)
http://resources.arcgis.com/en/help/main/10.1/index.html#//00170000015s000000

Import XML Workspace Document (Data Management):
http://resources.arcgis.com/en/help/main/10.1/index.html#//00170000014s000000

Methods for copying geodatabases(old link but still valid):
http://webhelp.esri.com/arcgisserver/9.3/java/index.htm#geodatabases/method-1755117318.htm

Note: Always try to provide your configuration details(Desktop version, DBMS version,etc) for a more appropriate answer/suggestions/links.
Reply
0 Kudos
MarcoBoeringa
MVP Regular Contributor
Are you sure Geodatabase Replication isn't suitable for your scenario? This would save you from trying to handle this through models, and additionally have the benefit of just copying over changes, instead of everything.

See the Understanding distributed data and Scenarios using distributed data as starters to Geodatabase Replication.
Reply
0 Kudos
ChrisCyphers
New Contributor
This was the error that I recieved when using the copy tool.  I forgot to mention earlier that I'm using version 10.1.

Executing (Copy): Copy "Database Connections\WA@gas@gis.sde" "M:\GIS Data Services Group\DataReviewerTest\Geodatabases\Gas.gdb" Workspace
Start Time: Fri May 09 13:06:26 2014
ERROR 000260: Failed to copy Database Connections\WA@gas@gis.sde into M:\GIS Data Services Group\DataReviewerTest\Geodatabases\Gas.gdb
Failed to execute (Copy).
Failed at Fri May 09 13:06:28 2014 (Elapsed Time: 2.00 seconds)

I tried the xml tools but the SDE db is too large and takes forever.

Thanks for the replication idea.  I think I may look into it next.
Reply
0 Kudos
AsrujitSengupta
Regular Contributor III
Is the Gas.gdb located on a network drive? If yes, can you try a local drive and check.
Reply
0 Kudos