How to merge data in ArcSDE using SQL

RachelS

Hi,

I have datasets with one to many relationships to tables.

These identical datasets and tables are in geodatabases by year.

I'd like to merge the years as the schema is the same every year.

However, I see if I merge them, the object ID changes and this is the only link I have to one of the tables REl_OBJECTID.

The table shows photos uploaded.

Is there any other way I can merge them, or will I just leave them separate for each year?

Thanks

R

Anonymous User

Hello all

I think you can try this approach:

- On each feature class/table create a new field. Populate this field with using "Field calculator", joining year+objectid (in the related table. ex. 20151234 ,for the 2015 dataset and the objectid 1234); in the related table you can use:  year+REl_OBJECTID .

Now you have an aditional field on each featureclass/table you can use to create the relatioship class. If you can identify anyway the year of each feature dataset, sure you can write an python script for automating this task.

Once you have created all the fields in the featureclasses/tables, merge them.

You can rebuild the relationship class using the new fields. Now you can decide If you continue with these fields or... simply, using the new relationship, calculate the "old" REI_OBJECTID field in the table to point to the new OBJECTID values in the feature class.

Hope this helps

Jesús de Diego