Skip to main content
Question

Feature class backup copy in SDE


d.jimenez
Contributor
Forum|alt.badge.img+3

I’m stuck with something I thought should be straightforward. I need to create backup copies of existing feature classes hosted within an SDE. Backup copies will need going into a Feature Dataset ‘ss’ that sits inside the same SDE hosting the feature classes. FC1 will have fields ‘Field1’, ‘Field2’ and ‘Field3’, and FC2 will have fields ‘Field4’, ‘Field5’ and ‘Field6’. I can do this easy if I read and write these two feature classes as Individual Feature Types, however I was hoping for a more elegant way to do this with Single Merger Feature Types and a Dynamic Writer that would fan out the individual feature classes honouring their schemas. When I try this second approach, resulting FC1 backup copy will have its fields ‘Field1’, ‘Field2’ and ‘Field3’, but also ‘Field4’, ‘Field5’ and ‘Field6’ that have been transferred from FC2’s schema. Same goes for FC2 which will also have FC1’s fields on it. What am I doing wrong?

image

4 replies

Forum|alt.badge.img+2
  • August 22, 2022

@d.jimenez​ Check your Schema Sources. Make sure you're not pulling from several sources and only using the Schema Feature. Perhaps on the dynamic reader feature type, make sure you remove all the source attributes that might be floating around from when you created the workspace. Can you attached a copy of your workspace?


d.jimenez
Contributor
Forum|alt.badge.img+3
  • Author
  • Contributor
  • August 23, 2022
markatsafe wrote:

@d.jimenez​ Check your Schema Sources. Make sure you're not pulling from several sources and only using the Schema Feature. Perhaps on the dynamic reader feature type, make sure you remove all the source attributes that might be floating around from when you created the workspace. Can you attached a copy of your workspace?

Thanks @Mark Stoakes​. It won't run if Schema Sources set to "Schema From Schema Feature" returning below error:

 

imageAttached workspace for reference - thanks!


Forum|alt.badge.img+2
  • August 29, 2022

@d.jimenez​ Thanks for including the workspace. You don't have a schema feature. You only have the source dataset. So I think you might have to select the SDE Geodb reader as your schema and also Geometry From First Feature

image


d.jimenez
Contributor
Forum|alt.badge.img+3
  • Author
  • Contributor
  • August 30, 2022

@Mark Stoakes​ thanks! I think I figured it out, I saw elsewhere that 'Add Reader as Resource' was used to solve a similar query and it's worked great here also. The reader 'schema' will be added as a resource under 'Workspace resources' and this is the schema that has to be selected in the writer as 'Schema Source'. Selecting instead the SDE geodatabase reader as the schema source will result in each feature class having all the fields from all other feature classes as well which is what I'm trying to avoid. Thank you


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings