topic Re: Script to automatically copy local GDB to ArcSDE in Data Management Questions

Script to automatically copy local GDB to ArcSDE

ScottBodien — Thu, 29 Sep 2011 19:44:28 GMT

Hello, I am looking for a script or help in automating the process of daily copying over a file GDB on my local C drive to a ArcSDE server in our organization. Am using 10.

Thanks!
Scott

Re: Script to autmatically copy local GDB to ArcSDE

JakeSkinner — Fri, 30 Sep 2011 11:26:08 GMT

Hi Scott,

Can you elaborate a little more on what you will be copying (i.e. tables, feature classes, etc)? What is the purpose of a daily copy from your FGD to SDE? Is it to update the SDE feature classes with edits that were created in the FGD? If so, have you considered geodatabase replication? This will allow you to synchronize changes from the FGD to SDE with a click of a button.

Re: Script to automatically copy local GDB to ArcSDE

afafabbas — Mon, 22 Sep 2014 23:23:49 GMT

Hi Jake,

I'm trying to import FGDB to ArcSDE using ArcCatalog. FGD has 41 feature classes and tables. ArcCatalog keeps crashing. I tried normal copy and paste, it didn't work either. The FGDB has an xml associated with it. I'm working on ArcGIS V 10.2. Any idea how to get the FGDB imported/copied to ArcSDE smoothly?

Thanks,

Afaf

Re: Script to automatically copy local GDB to ArcSDE

GeoffreyWest — Mon, 22 Sep 2014 23:25:38 GMT

Export/Import XML Workspace document should be a good solution.

Re: Script to automatically copy local GDB to ArcSDE

AsrujitSengupta — Tue, 23 Sep 2014 12:20:21 GMT

Are you trying to copy all the 41 feature classes together and observing the crash? Did you try copying a subset of the data and check if that works or not.

Does it crash only while copying data to the sde gdb or to any geodatabase?

Re: Script to automatically copy local GDB to ArcSDE

Anonymous User — Tue, 23 Sep 2014 20:01:12 GMT

Is your requirement to wholesale replace the entire feature classes in SDE, or import modified records? Also, what prevents you from editing in SDE instead of on your C drive?

Re: Script to automatically copy local GDB to ArcSDE

afafabbas — Tue, 23 Sep 2014 21:11:25 GMT

Yes I’m trying to copy the whole GDB that contains 41 feature class and tables . It copied some of them (about 6 feature classes) then crashed. When I copy them one by one, first it takes ages to copy and second and most important, it didn’t recognizes me as a GDB administrator, therefore I can’t register it versioned or create attachments which required for feature class editing on webmap.

Thanks ,

Afaf

Re: Script to automatically copy local GDB to ArcSDE

afafabbas — Tue, 23 Sep 2014 21:18:01 GMT

The GDB comes from client. It’s been designed with domains and subtypes already, I just need to import them to ArcSDE, add them to a webmap, so the client can edit the data through the webmap (multiuser editing)

Thanks,

Afaf

Re: Script to automatically copy local GDB to ArcSDE

Anonymous User — Tue, 23 Sep 2014 21:52:29 GMT

Sounds like a geodatabase check-out replica might work. It is quick and easy once you're accustomed to the workflow, and is designed for the exact purpose you describe. This allows you to communicate only the deltas, which will drastically reduce your "copy" time. Here's a link: ArcGIS Desktop

Re: Script to automatically copy local GDB to ArcSDE

afafabbas — Tue, 23 Sep 2014 22:36:01 GMT

Thanks Marianne, I’ve used replica once before, so I’m new to using Replica. I followed the instruction in the help link, ‘Creating a Check- out Replica’, all codes in the Distributed Geodatabase toolbar are not active except the ‘Extract Data’ for some reason ☹

Thanks,

Afaf

Re: Script to automatically copy local GDB to ArcSDE

Anonymous User — Tue, 23 Sep 2014 22:47:46 GMT

The checkout replica is created from an mxd with all of the data to be "checked-out" sourced to SDE. I'm guessing the mxd you're using right now is sourced to the file geodatabase.

You need to get the fgdb data into SDE first, then create your check-out replica. Consider the Extract Data tool for this: ArcGIS Desktop

You're in a little bit of a pickle. The immediate problem will be best solved with either Extract Data, or replacing the SDE feature classes with the fgdb feature classes, or using python to delete the existing SDE records and replace them with the fgdb feature class records. None are pretty, each have good and bad sides, but checkouts will help you after this step is done.

Re: Script to automatically copy local GDB to ArcSDE

afafabbas — Tue, 23 Sep 2014 22:55:14 GMT

Great thanks Marianne, I will give it a try this way and update you hopefully with good news.

Regards,

Afaf