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.
- 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 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 set a 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 set a 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 set a 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 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.
- Select OK.