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 ) )

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.

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

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

copy feature dataset to feature dataset

JaredPilbeam1

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:

<SPAN class="comment token"># Import modules</SPAN>
<SPAN class="keyword token">import</SPAN> os
<SPAN class="keyword token">import</SPAN> arcpy

<SPAN class="comment token"># set workspace</SPAN>
env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"T:\Departments\E911\Transfer Files\E911WeeklyUpdate\E911WeeklyUpdate.gdb"</SPAN>

<SPAN class="comment token">#create a list of feature classes in the current workspace</SPAN>
fclist <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListFeatureClasses<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token">#copy each feature class to a fgdb </SPAN>
<SPAN class="keyword token">for</SPAN> fc <SPAN class="keyword token">in</SPAN> fclist<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; fcdesc <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Describe<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>CopyFeatures_management<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">,</SPAN> os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>"Database Connections\
&nbsp;&nbsp;&nbsp; Jared to plainfield<SPAN class="punctuation token">.</SPAN>sde\gisedit<SPAN class="punctuation token">.</SPAN>DBO<SPAN class="punctuation token">.</SPAN>MGU_Will"<SPAN class="punctuation token">,</SPAN> fcdesc<SPAN class="punctuation token">.</SPAN>basename<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Find more posts tagged with

Accepted answers

All comments

Asrujit_SenGupta

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.

JaredPilbeam1

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:

Clip_1497.jpg

RebeccaStrauch__GISP

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.

Asrujit_SenGupta

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.

davidchamberlain2_0-1728034352519.png

NigelGriffiths_0-1728035996463.png

NigelGriffiths_1-1728035996471.jpeg

NigelGriffiths_2-1728035996477.png

Asrujit_SenGupta

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.

JaredPilbeam1

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’.

RebeccaStrauch__GISP

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

Replication types—ArcGIS Help | ArcGIS for Desktop

JaredPilbeam1

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.

DarrenWiens2

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.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.