topic Re: copy feature dataset from sde to sde in Geoprocessing Questions

copy feature dataset from sde to sde

MikeJun — Wed, 26 May 2010 15:55:01 GMT

I just want to loop through all feature dataset and copy to other sde. It seems like running forever when I run the following python code.

import arcgisscripting
gp = arcgisscripting.create()
gp.SetProduct("ArcInfo")
gp.Overwriteoutput = 1

gp.AddToolbox("C:/Program Files (x86)/ArcGIS/ArcToolbox/Toolboxes/Data Management Tools.tbx")

gp.workspace = "S:\_GIS\_AutoProcess\dataconnections\sdeTEST_COBGISSDE.sde"

varCOB = "S:\_GIS\_AutoProcess\dataconnections\sdePROJ_COBGISSDE.sde"

try:
   datasets = gp.ListDatasets()
   dataset = datasets.next()

   while dataset:
     gp.Copy_management(dataset, varCOB + dataset, "FeatureDataset")
     dataset = datasets.next()

except:
    print gp.getmessages(2)

Re: copy feature dataset from sde to sde

MikeJun — Fri, 28 May 2010 22:47:58 GMT

I figured out myself. I need to put double forward slash.

ex)

gp.workspace = "S:\\_GIS\\_AutoProcess\\dataconnections\\sdeTEST_COBGISSDE.sde"

gp.Copy_management(dataset, varCOB + '\\' + dataset, "FeatureDataset")

Re: copy feature dataset from sde to sde

VaL — Thu, 11 Mar 2021 09:33:00 GMT

Sorry for digging up this topic but I want to do the same: FDS copy from SDE to SDE.

My set up is

SDE1 - oracle w/r access

SDE2 - MS SQLS w/r access

SDE 1nad 2 are on different machines in the network. Typical bandwidth is ~2-5 MB/s.

Using arcgis pro 2.6.

SDE FDS has only feature classes and relationship classes. Outside of it in SDE1 DB there are more tables and relsh. classes. Both are linked with FDS.

Using copy-paste on the DS pops up an error

Paste failed. Invalid name.

in pro.

It does this for any item (DS, FC, table) simply copy-pasted wont work.

If using the script above - it starts and hangs for hours. Is that normal.

What is the best way to copy FDS from one SDE to another? As a bigger picture I need to completely make a copy of the full SDE1 DB to SDE2 DB - all in - FDS, tables, RClasses, domains etc. What would be the best way to do so?