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
17.00
Published
November 30, 2021
Language
English (United States)
Last Update
2021-11-04
dita:mapPath
gmn1574692806523.ditamap
dita:ditavalPath
cjo1509024828169.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 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.
  • DSA automatically copies 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>