topic Re: Copy SDE Database to File Geodatabase in Data Management Questions

Copy SDE Database to File Geodatabase

ChrisCyphers — Fri, 09 May 2014 13:35:45 GMT

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.

Re: Copy SDE Database to File Geodatabase

AsrujitSengupta — Fri, 09 May 2014 13:57:31 GMT

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.

Re: Copy SDE Database to File Geodatabase

MarcoBoeringa — Fri, 09 May 2014 14:06:33 GMT

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.

Re: Copy SDE Database to File Geodatabase

ChrisCyphers — Fri, 09 May 2014 16:12:28 GMT

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.

Re: Copy SDE Database to File Geodatabase

AsrujitSengupta — Fri, 09 May 2014 17:16:32 GMT

Is the Gas.gdb located on a network drive? If yes, can you try a local drive and check.