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

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
17.10
Release Date
June 2021
Content Type
User Guide
Publication ID
B035-4101-061K
Language
English (United States)
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>