I am working with two ArcSDE geodatabases -- one for test, one for production. They both have the same schema. I recalculated an attribute in the test environment and wanted to push that to production. My instinct was to join the two feature classes and use the Field Calculator, but there was no way to distinguish which column belonged to which database. So I appended
_TEST to the aliases of the test class. When I ran the join again, it automatically appended
_TEST to the production aliases as well. [grunt] Somehow I figured out which was which and was ready to use Field Calculator but... the option was grayed out in the right-click menu for the column. All columns, in fact. So my main question is:
How is it possible to join feature classes from two ArcSDE geodatabases and copy attribute values from one to the other?
Secondly, why on earth were my production field aliases being suffixed with
_TEST? It seems like ArcMap has no way of managing a join between feature classes with the same field names. Is this true?