This feature enables you 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 over another platform.
This might be required when:
Table or field naming conventions
have changed, and many tables/fields have been renamed.
Table or field naming conventions
for an application vary with different database engines.
To Change Table Or Field Names
In the Workbench, click View > Options. The Application Options dialog box appears.
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 check box. Otherwise, any
changes are reversed when the DTS file is saved.