topic Re: How to maintain symbology, definition query, and label expression when changing join source in Mapping Questions

How to maintain symbology, definition query, and label expression when changing join source

ZacharyPierce — Wed, 05 Nov 2014 17:51:04 GMT

Hello all,

Huge question, that is somewhat time sensitive. We have created 3 mxd's in a DEV environment with a lot of symbology classes, definition queries, and label expressions all based off the Joined data fields. Now that we have moved to TEST, our source for the joins need to be connected to an oracle TNS name of TST instead of DEV.

The issue is when I remove the current join, I lose all of those definitions. If I try to add the new join first, and then remove the old one, it removes both. Why can't I ONLY remove the old join and keep the new one? This would keep all the definitions in place and switch the source.

Is there a way to just UPDATE the join data source instead of deleting it.

I would hate to have to save individual layer files for symbology, individual expressions for labels for each feature, and then save the definition queries as well, then manually re apply everything.

I hope I am missing something simple here... someone PLEASE help!

Thanks,

Zach!!

Re: How to maintain symbology, definition query, and label expression when changing join source

KishorGhatage — Tue, 28 Apr 2015 05:44:56 GMT

Take backup of your MXD and try changing data sources:

ArcGIS Help (10.2, 10.2.1, and 10.2.2)

Hope this helps

Kishor

Re: How to maintain symbology, definition query, and label expression when changing join source

NeilAyres — Thu, 30 Apr 2015 07:20:36 GMT

Wouldn't saving your layer as a layer file, then re-load it, do what you want to do?

As long as all the field names are the same, the symbology should work fine.

Re: How to maintain symbology, definition query, and label expression when changing join source

SepheFox — Thu, 30 Apr 2015 13:37:06 GMT

Yes, this would work, but the OP was looking for an automated way, since he has 3 mxds and a lot of symbology classes.

Re: How to maintain symbology, definition query, and label expression when changing join source

ZacharyPierce — Tue, 02 Jun 2015 15:55:12 GMT

In short, I was told this was not possible based on the direction of by data source changes and the data source. ( Called Esri Support)