Exporting by Database - System Emulation Tool

Teradata System Emulation Tool User Guide

Product
System Emulation Tool
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-07
dita:mapPath
lth1488824663584.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2492
lifecycle
previous
Product Category
Teradata Tools and Utilities
Use the export-by-database method to select database objects for individual export and to define the information to export.
  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.
  4. Specify a path to the folder in which to save the file.

    By default, the In Folder box displays the path specified in the Options dialog box. See Directory Options.

  5. Click OK.

    The Export By Database dialog box appears.



  6. Define the export source by choosing one of the following:
    Choice Action
    Export from an entire database or from a user Do one of the following:
    • 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.
    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.
    Export from an individual database object
    1. In the List of Objects pane, select the object.
    2. Click Add to move the object to the Selected List pane.
    3. Repeat the previous two steps until all of the required objects are in the Selected List pane.
    Find a database object To find a database object, do the following:
    1. Click on an object in the List of Objects pane.
    2. To search in the selected list of objects, click on an object in the Selected Lists pane.
    3. Click Find Object.

      The Find dialog box appears.

    4. Enter an object name in the Find what field.
    5. Select any other find options on the dialog box, and then click Find Object.
    6. Click Add to move the object to the Selected List pane.
    To remove an object from the Selected List pane, select it and click Remove.
    Add multiple databases for export
    1. 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.
    2. Click Add to move the object to the Selected List pane.
    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.
    Add multiple query-capture databases for export
    1. Select the check box Query Capture Database.
    2. 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.
    3. Click Add to move the object to the Selected List pane.
    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.
  8. [Optional] To further define the selected export options, click Options. The Export Options dialog box appears. The options available in the 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, do the following:
    1. In the List of Objects pane, right-click the name of a database to display the shortcut menu.
    2. Click Mark as QCD.


      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 and Viewing the Estimated Export Time.
  11. Click Export to begin the export process. After the export operation completes, a summary report of the export operation results appears. See Viewing a Summary Report.