Copy Database | Data Mover Portlet | Teradata Data Mover - Copying a Database - Teradata Data Mover

Teradata® Data Mover User Guide - 20.01

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Data Mover
Release Number
20.01
Published
November 2023
Language
English (United States)
Last Update
2023-12-05
dita:mapPath
hlv1700545853003.ditamap
dita:ditavalPath
mpm1591127278842.ditaval
dita:id
don1467241476387
Product Category
Analytical Ecosystem
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.
  1. In the Objects tab, click "" to expand the tree.
  2. 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.
  3. [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.
  4. [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.
  5. [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.
  6. [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.
  7. [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.
  8. [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.
  9. Select OK.