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.05
Published
October 2020
Language
English (United States)
Last Update
2020-11-18
dita:mapPath
xxl1591023586203.ditamap
dita:ditavalPath
mpm1591127278842.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>