- Before importing data, connect to a Teradata Database.
- Select an export method. See Export Methods and Options.
- Export the information needed to emulate the target environment on the test system. See Export Methods and Options.
- Import the information to the test system, modifying the import options if necessary. See Import Methods and Options.
- Manage the imported data by doing the following (see Administrative Functions):
- Remove emulation information.
- Delete files.
- Email data to another location.
- Troubleshoot the import and export processes.
A .mcf file is created when emulation information is exported from a target system. This file includes pointers to the raw data files that are also created during export. During an import operation, the data in these files is applied to the default location specified in the following table.
Import Item | Default Import Location | Change Location |
---|---|---|
Cost parameters | SystemFE.Opt_Cost_Table and Opt_DBSCtl_Table | No |
Cost profiles | Data Dictionary | No |
Demographics | Export Demographics Source | Yes |
Execution plans | Export QCD | Yes |
Object definitions | Export database | Yes |
RAS | SystemFE.Opt_RAS_Table | No |
Statistics | Data Dictionary | No |
Workload data | Export QCD | Yes |
Multiple Hash Maps |
SystemFE.Opt_Map_Table SystemFE.Opt_MapRel_Table |
No |
To change the owner of databases or users, use the Parent Database box in the Import Options dialog box. To change the QCD, use the Target QCD box in the Import Options dialog box. See Changing Import Options.
To change the location or target database where objects are created, use the Rename function in the Import window. See Renaming a Target Database.