15.00 - Export by Database - System Emulation Tool

Teradata System Emulation Tool User Guide

prodname
System Emulation Tool
vrm_release
15.00
category
User Guide
featnum
B035-2492-034K

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 31.

4 Specify a path to the folder in which to save the file named in step 3 by doing one of the following:

  • In the In folder box, type a path.
  • Click Browse to locate a destination folder using Windows Explorer.
  • By default, the In Folder box displays the path specified in the Options dialog box. See “Directory Options” on page 56.

    5 Click OK.

    The Export By Database dialog box appears.

    6 Define the export source by doing one of the following:

  • To export from an entire database or from a user, either:
  • Enter the name of the database or user in the Specify Export Database box.
  • Click to select a database or user from the Specify Export Database list.
  • 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.

  • To export from an individual database object:
  • 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.

  • To find a database object:
  • 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.

  • To add multiple databases for export:
  • 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:
  • Enter the name of the database or user in the Specify Export Database box.
  • Click the browse button to select a database or user from the Specify Export Database list.
  • 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.

  • To add multiple query-capture databases 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:

  • Enter the name of the query-capture database in the Specify Export Database box.
  • Click the Browse button to select a query-capture database from the Specify Export Database list.
  • 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 79.

    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 24. and “Estimate Export Time” on page 92.

    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 136.