You can copy database objects to the same or to a different location on a target Teradata system. You can choose a staging database for tables and a separate staging base for temporary artifacts that are created, such as work, log, or error tables, or macros. You can also choose to replace an entire database by eliminating all of the objects in the target database and replacing them with those from the source database.
Databases cannot be copied between Teradata and Aster or Hadoop systems.
-
In the Objects tab, click
to expand the tree.
-
Click
to the right of the database name to display the Database Settings dialog box for the object.
The dialog box opens, with the name of the database displayed at the top.
-
[Optional] To the right of Map to a different database on target, click and select a database.
You can use the filter to display only the items that match the characters you enter.
-
[Optional] To the right of Source staging database for tables, click and select a source database.
You can use the filter to display only the items that match the characters you enter.
-
[Optional] To the right of Target staging database for tables, click and select a target database.
You can use the filter to display only the items that match the characters you enter.
-
[Optional] To the right of Target staging database for temporary artifacts, click and select a target database.
You can use the filter to display only the items that match the characters you enter.
-
[Optional] To enable or disable copying the journal attribute for source tables when using Teradata ARC, select an option from the Journaling list.
The Journaling setting s ignored if the database is not selected.Option Description Default or True Default setting. The job copies all tables that use a journal to the target with the journal attribute. False The job copies all tables to the target with no journal attribute. -
[Optional] To verify that important aspects of the DDL for the source and target tables match before performing the copy, select an option from the Compare DDL list.
Option Description Default By default, Data Mover compares the DDL. True Compare the DDL before performing the copy. False Do not compare the DDL before performing the copy. - [Optional] To eliminate all objects in the target database that do not exist in the source database, click the Replace entire target database check box. Selecting this check box removes any additional tables that existed on the target database, but not on the source database.
- Click OK.