Is there a way to check if source feature class schema matches exactly with destination feature class . If not throw error ?
Question
throw error if schema doesn't match
Hello ,
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+1Hello,
You could set up various tests, if you need to check the schema of the data. However, if you just want to ensure that the source data schema is replicated on the output, you can use a dynamic writer.
Owen
Hello Owen,
I need to check schema between source and destination feature class if the schema matches then I have to proceed loading the data from source to destination or else terminate .
Is there any way I can do the above using dynamic reader and dynamic writer ?
+1Does the table already exist in the destination database?
+1Depending on the format, you can use a Schema Reader to read the source and destination schemas, a listexploder then merge them using a featuremerger, joining on feature_type_name, field name, data_type. If anything comes out of the 'unmerged' port, then you could terminate the workspace.