Copy an Entire Database | Teradata Data Mover - Copying an Entire Database - Teradata Data Mover

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
16.20
Published
November 2021
Language
English (United States)
Last Update
2021-11-04
dita:mapPath
wph1512683331242.ditamap
dita:ditavalPath
4101_UG_dm_1620.ditaval
dita:id
B035-4101
lifecycle
previous
Product Category
Analytical Ecosystem
The following applies when copying an entire database:
  • You can copy all tables and views from a source to a target database using Teradata ARC or Teradata DSA.
  • If copying a table that already exists on the target, the target table is overwritten. If the target database contains tables that do not exist on the source or the tables are not being copied, those tables are maintained on the target. The exception is when using DSA to copy data to a target database with a version earlier than 16.20, in that scenario the tables are deleted.
  • Both ARC and DSA automatically copy statistics collected on all tables in the source database to the target database.
  1. Open the parameters.xml file that has the job definition information for the job.
  2. Add the selection="included" attribute to the database element.

In the following example, all objects in the source database DBName are copied to the target:

<database selection="included">
    <name>DBName</name>
</database>