Use the Find/Replace feature to globally replace text in table or field
names when loading or opening a DTS file. This
feature allows a DTS file built with one database engine or platform to
be used on another platform.
This might be required when table or field naming conventions:
Have changed and many tables/fields have been renamed
For an application vary with different database engines
To make a global name change
In the Workbench, click View > Options.
Click the Find/Replace
tab.
Enter the Table Prefix and/or
Suffix text that you want to replace in one or more of the Find fields.
Enter the text to substitute
for the found text in the corresponding Replace field(s).
If you want to save changes made to
any tables or fields, select the Always
save replacements checkbox .
Note: If
you clear the checkbox, any changes are reversed when you save the DTS
file.
For changes to take place, close
and then re-open the DTS file.