I have an MXD. It connects to about 30 layers in one of our SDE databases. I want to change the SDE database they connect to. Is there a way to do this without having to right-click every layer and change it individually?
Right click on the mxd in ArcCatalog, click on Set data sources, and bulk change from there. However, this tool warns:
Note: this dialog is intended primarily for preparing map documents for publication. Customizations (VBA code, UI Controls and custom toolbars), graphs, and table window appearance properties are removed from .mxd files when you update their data sources using this dialog. To preserve these, update the data sources in ArcMap instead.
You could also use the arcpy.mapping python library:Tweet