Rename a Target Database
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:
Use the Replace dialog box to change the database name for all object definitions.
To rename a target database
This procedure can be performed offline or while connected to a Teradata Database.
1 Do one of the following:
See “Connect to a Teradata Database” on page 29.
The Open dialog box appears and displays the available .mcf files.
2 Select an .mcf file.
3 Click Open.
4 From the Import window, select the target database to rename.
5 From the toolbar, click .
6 Type a new database name.
7 Press Enter.
A confirmation message appears.
8 [Optional] To prevent the message from appearing each time this procedure is performed, select the Don’t ask this question again check box.
9 [Optional] To keep the original database name in the object definitions, click No.
The status bar displays:
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.
10 [Optional] To update the name change in the object definitions, click Yes.
The Replace dialog box appears.
11 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 the Find what box 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 used in the Find what box. |
Search in all DDLs |
Search all object definitions. This check box is selected by default. |
12 Find and replace the database name in the object definitions:
a Click Find Next to find the next matching instance in the object definitions.
b Do one or more of the following:
The import tree in the left pane expands, and the corresponding DDL is selected.
The total number of replacements appears at the bottom of the Replace dialog box.
The total number of replacements appears at the bottom of the Replace dialog box.
Note: 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.
13 After all of the intended replacements have been made, click Cancel to close the Replace dialog box.
14 To commit the name change, click .
The status bar displays Changes applied
.
Note: All changes must be committed and applied before conducting the import operation. The changes are applicable only to the next import operation. See “Import to a Test System” on page 93.