AnsweredAssumed Answered

How to merge data in ArcSDE using SQL

Question asked by RachelB on Jan 13, 2015
Latest reply on Feb 4, 2015 by RachelB



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?