The following procedure describes how to use Schema Migration Assistant to format an existing Teradata Schema Workbench 13.10-created schema for compatibility with Teradata Schema Workbench 14.00 and above.
For a smoother migration process, follow the instructions in Preparing Schemas for Migration before performing this procedure.
- To start Schema Migration Assistant, from the Windows Start menu, select .
-
Click Browse for the 13.10 Schema file, and select a schema file for migration.
The 14.00 Schema file and Translation Log file fields automatically load to the same directory as the 13.10 source. By default, Schema Migration Assistant renames the target file for conversion to be the same as the original, appending 14.00.
-
Click Start Migration.
The log window displays the following:
- High level information
- Elements and formulas renamed to avoid conflict
- Any errors or warnings for unsupported elements (cycles, degenerate dimensions, multiple hierarchies in the same dimension using different leaf member tables).
Schema Migration Assistant automatically renames any duplicates among the elements. -
When migration completes, review the log window and click OK.
Schema Migration Assistant only saves new schema if translation is successful. Schema Migration Assistant saves the log file whether the translation is successful or not. The log contains translation details, any element renaming, errors, and warnings.
- Check the log file for elements automatically renamed during the migration process. If you find automatically named elements, modify them in Teradata Schema Workbench 15.10 for more meaningful names.
- Finish the instructions in Completing Migration in Teradata Schema Workbench 15.10.