Description
The ArcPy mapping module provides methods on the MapDocument object to perform global find and replace workspace paths for all layers and tables in a map document. These methods include:
MapDocument.findAndReplaceWorkspacePaths
MapDocument.replaceWorkspaces
These methods migrate Joins and Relates for Layers. The ArcPy mapping module also provides a number of methods from the Layer and TableView objects that allow changes to a Layer or TableView's workspace path or data source. These methods include:Layer.findAndReplaceWorkspacePath
Layer.replaceDataSource
TableView.findAndReplaceWorkspacePath
TableView.replaceDataSource
When using one of these Layer or TableView methods to change the workspace path or data source of a Layer or TableView that has a join or a relate to a data source also in the new workspace, the workspace path or data source of the joined or related table will not be updated.
Cause
This is a known limit at ArcGIS 10. For updates on the status, use bug number NIM058535.
Workaround
When using one of the Layer or TableView methods to change the workspace path or data source of a Layer or TableView that has a join or a relate to a data source also in the new workspace, the workspace path or data source of the joined or related table needs to be updated manually by way of the user interface.