topic Re: copy feature dataset to feature dataset in Developers Questions

copy feature dataset to feature dataset

JaredPilbeam1 — Fri, 10 Dec 2021 22:36:38 GMT

Every script I've tried isn't able to copy the feature dataset in the top image to the bottom feature dataset (in an SDE).

It's probably something simple, but is there a known function for this? I can't change anything in the SDE as I don't have administrative rights to it.

I've tried Copy_management. But, here the in_data and out_data variables must have the same file extension to work properly.

I've also tried CopyFeatures_management. Here's the syntax and error message for that:

# Import modules
import os
import arcpy

# set workspace
env.workspace = r"T:\Departments\E911\Transfer Files\E911WeeklyUpdate\E911WeeklyUpdate.gdb"

#create a list of feature classes in the current workspace
fclist = arcpy.ListFeatureClasses()

#copy each feature class to a fgdb 
for fc in fclist:
    fcdesc = arcpy.Describe(fc)
    arcpy.CopyFeatures_management(fc, os.path.join("Database Connections\
    Jared to plainfield.sde\gisedit.DBO.MGU_Will", fcdesc.basename))‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: copy feature dataset to feature dataset

DarrenWiens2 — Fri, 09 Dec 2016 22:33:08 GMT

Try 'print fclist'. It looks like there's nothing there.

Also, there's something fishy going on. You should get an error at 'env.workspace' since you haven't imported env.

Re: copy feature dataset to feature dataset

JaredPilbeam1 — Mon, 12 Dec 2016 16:47:06 GMT

Thanks Darren.

I scrapped that script any tried arcpy.Copy_management. Basically, I'm trying to replace a feature dataset within an sde (here: plainfield.sde) with a dataset from a local gdb, as the features change weekly. The rewritten script below gets an error in the part of the script that attempts to copy from the local gdb (E911WeeklyUpdate.gdb\MGU_Will) to the plainfield.sde. Can you write to an sde? I haven't read anywhere that you can't.

Re: copy feature dataset to feature dataset

RebeccaStrauch__GISP — Mon, 12 Dec 2016 17:11:17 GMT

You may want to look at 2-way replication, if you haven't already.

Replication types—ArcGIS Help | ArcGIS for Desktop

Re: copy feature dataset to feature dataset

JaredPilbeam1 — Mon, 12 Dec 2016 18:58:18 GMT

Sorry, my pseudocode is misleading. Let me clarify a bit more.

I’m trying to copy a dataset from a local gdb to an sde. This dataset already exists in the sde—I just need to update it with the dataset from the local gdb. There’s a schema lock error. I don’t have the database open and the ‘Jared to plainfield.sde’ version used in this script is a copy of the main sde called ‘ims to Plainfield’. But, I’m not the administrator and surely there are other GIS people in the building using the sde. I’m only using the ‘Jared’ version to practice run this script, then I want to use it on the ‘ims to Plainfield.sde’.

Re: copy feature dataset to feature dataset

Asrujit_SenGupta — Mon, 12 Dec 2016 19:15:51 GMT

Is the Feature Dataset in sde Registered as Versioned? If not, you can look into running the "Truncate Table" tool on the Feature Classes in the sde gdb and then loading data from the File gdb features classes into the empty FCs.

You can try disconnecting all connections to the sde geodatabase in the script and execute the rest as you are doing now.

Re: copy feature dataset to feature dataset

Asrujit_SenGupta — Mon, 12 Dec 2016 19:19:43 GMT

Versions in an Enterprise Geodatabase refers to a completely different concept.

I assume what you are referring to is the Connection File name (the images attached are too small to see clearly) pointing to a Test env for now, before using it against the Production\main Enterprise gdb.

Re: copy feature dataset to feature dataset

RebeccaStrauch__GISP — Mon, 12 Dec 2016 19:29:43 GMT

But, I’m not the administrator and surely there are other GIS people in the building using the sde.

If you are not the administrator for the sde database, do you know if you have write permissions?

re: locks

Manage geodatabase locks—Help | ArcGIS for Desktop but again, if you are not the administrator, you may not be able to do much with it.

Re: copy feature dataset to feature dataset

JaredPilbeam1 — Mon, 12 Dec 2016 19:44:42 GMT

I have no control over the locks, apparently. After right clicking the feature class within the feature dataset, 'locks' is grayed out.

Here are the above images made larger:

Re: copy feature dataset to feature dataset

Asrujit_SenGupta — Mon, 12 Dec 2016 19:49:56 GMT

These Datasets are owned by DBO, which is a Admin login. You cannot delete these datasets, connected as any other login, other than the Admin (any login which has been granted 'sysadmin' role).

So you must look into this aspect first.

Re: copy feature dataset to feature dataset

JaredPilbeam1 — Mon, 12 Dec 2016 19:52:32 GMT

Thanks Asrujit,

So, generally speaking, you can't write to an SDE without administrative rights?

Re: copy feature dataset to feature dataset

Asrujit_SenGupta — Mon, 12 Dec 2016 19:57:04 GMT

No, you surely can. But from the Image that you attached, it seems that in your sde gdb, an Admin login was used to load\create the data.

In an Enterprise geodatabase, only the Data Owner can delete the data from the geodatabase. Permissions can be given to other users for viewing and editing, but the right to delete the data remains with the owner always.

This rule even applies, when the Data has been created using a Non-Admin login and then an Admin tries to delete it.