You can import member mappings for partitions from an external text file instead of creating the mappings manually.
The mappings file must have a .txt extension and must contain two columns separated by tabs or spaces. One column contains the source members to be mapped and the other column contains the target members to be mapped. Member names containing spaces must be enclosed in quotation marks.
In the text file, the source members must be aligned with their corresponding target members so that the mappings import correctly.
To import member mappings for partitions:
Select the Mappings tab.
Click Import.
In the Import Member Mappings dialog box, populate the Mapping file text box using one of the following methods:
Enter the path and file name of a mappings file.
Click the Browse button and navigate to a drive and folder that contains a mappings file. Select the file and click Open.
In the Format settings option group, select Source column first (if the source member names are in the first column in the file) or Target column first (if the target member names are in the first column of the file).
The source and target columns must be separated by tabs or spaces.
Click OK.