Export by Database
Use the export‑by‑database method to select database objects for individual export and to define the information to export.
To export by database
1 From the main window, click .
The Export from Teradata Database dialog box appears.
2 Click Database.
3 In the File name box, type a file name for the exported emulation information.
By default, the File name box displays the name of the target system specified when connecting. See “Connect to a Teradata Database”on page 29.
4 Specify a path to the folder in which to save the file named in step 3 by doing one of the following:
By default, the In Folder box displays the path specified in the Options dialog box. See “Directory Options” on page 54.
5 Click OK.
The Export By Database dialog box appears.
6 Define the export source by doing one of the following:
Note: The Execution Plans check box is unavailable, by default, unless a database in List of Objects pane is marked as a QCD, or a database is selected from the Specify Export Database list and the Query Capture Database check box is selected.
i In the List of Objects pane, select the object.
i In the List of Objects pane, select the object.ii Click Add to move the object to the Selected List pane.
iii Repeat step i and step ii until all of the required objects are in the Selected List pane.
i Click on an object in the List of Objects pane.
i Click on an object in the List of Objects pane.To search in the selected list of objects, click on an object in the Selected Lists pane.
ii Click Find Object. The Find dialog box appears.
iii Enter an object name in the Find what field.
iv Select any other find options on the dialog box, and then click Find Object.
v Click Add to move the object to the Selected List pane.
Note: To remove an object from the Selected List pane, select it and click Remove.
i Specify the database or user in the Specify Export Database in either of the following ways:
i Specify the database or user in the Specify Export Database in either of the following ways:ii Click Add to move the object to the Selected List pane.
Note: If the Add button is not clicked, after specifying the database or user in the Specify Export Database box, only the database specified in the Specify Export Database box is available for export.
i Select the check box Query Capture Database.
i Select the check box Query Capture Database.ii Specify a query-capture database in the Specify Export Database box in either of the following ways:
iii Click Add to move the object to the Selected List pane.
Note: After selecting the Query Capture Database check box, and clicking the Browse button, only query-capture database names populate the Specify Export Database list. If the Query Capture Database check box is deselected and the Browse button is clicked, all database names populate the Specify Export Database list. If the Add button is not clicked after specifying a query-capture database in the Specify Export Database box, only the query-capture database names specified in the Specify Export Database box are available for export.
7 [Optional] Under Export Options, select check boxes to define the exported information. See “Export Options”on page 77.
8 [Optional] To further define the selected export options, click Options.
The Export Options dialog box appears. The options available in this dialog box depend on the selections made under Export Options on the Export By Database dialog box.
9 [Optional] To mark a database as a QCD:
a In the List of Objects pane, right‑click the name of a database to display the shortcut menu.
b Click Mark as QCD.
Note: The Execution Plans check box under Export Options is available only when the database is marked as a QCD.
10 [Optional] Click Estimate Time to see the estimated time required to process the export request.
See “Estimate‑Time Rights” on page 22. and “Estimate Export Time” on page 90.
11 Click Export to begin the export process.
After the export operation completes, a summary report of the export operation results appears. See “View a Summary Report” on page 134.