Renaming a Target Database - System Emulation Tool

Teradata® System Emulation Tool User Guide

Product
System Emulation Tool
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-19
dita:mapPath
log1544831946868.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2492
lifecycle
previous
Product Category
Teradata Tools and Utilities

Use Teradata SET to rename a target database when the database already exists on the test system and must remain on the test system.

The name change affects the following:
  • Statistics
  • RAS
  • DDLs of the objects in the database
  • DDLs of the objects that have dependencies on the renamed object

Use the Replace dialog box to change the database name for all object definitions.

This procedure can be performed offline or while connected to the database.

  1. Do one of the following:
    • When connected to the database, click .
    • When not connected to the database, click .
  2. Select an .mcf file, then click Open.
  3. From the Import window, select the target database to rename.
  4. Click .
  5. Type a new database name, then press Enter.
  6. [Optional] To prevent the confirmation message from appearing each time this procedure is performed, select Don’t ask this question again.
  7. [Optional] To keep the original database name in the object definitions, click No.
    The status bar displays the following message:

    Target database has been changed from old name to new name

    The target database name is changed. The object definitions are not renamed. Skip the remaining steps in this procedure.

  8. [Optional] To update the name change in the object definitions, click Yes.
  9. Define the search-and-replace operation using the options in the Replace dialog box.
    Option Description
    Find what Search for this database name.
    Replace with Replace the database name listed in Find what with this database name.
    Match whole word only Search for whole words. This check box is selected by default.
    Match case Search for characters that match the case in Find what.
    Search in all DDLs Search all object definitions. This check box is selected by default.
  10. Find and replace the database name in the object definitions:
    1. Click Find Next to find the next matching instance in the object definitions.
    2. Do one or more of the following:
      • Click Replace to replace the selected instance in a single object definition.

        The import tree in the left pane expands, and the corresponding DDL is selected.

      • Click Replace All to replace all instances of the database name in a single object definition.

        The total number of replacements appears at the bottom of the Replace dialog box.

      • Click Replace in all DDLs to replace all instances of the database name in all object definitions.

        The total number of replacements appears at the bottom of the Replace dialog box.

      The first time Replace is clicked, the Allow Edit command becomes available on the Edit menu. When editing is allowed, object definitions, RAS, statistics, cost parameters, DBS Control information, and cost profiles can be modified in the right pane of the Import window.
  11. After all of the intended replacements have been made, click Cancel to close the Replace dialog box.
  12. To commit the name change, click .
    The status bar displays Changes applied.
    All changes must be committed and applied before conducting the import operation. The changes are applicable only to the next import operation. See Importing to a Test System.