Functionality Introduction | Teradata Data Mover - 17.11 - Introduction to Teradata Data Mover - Teradata Data Mover

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
17.11
Release Date
October 2021
Content Type
User Guide
Publication ID
B035-4101-091K
Language
English (United States)

Data Mover enables you to define and edit jobs that copy specified database objects, such as tables, users, views, macros, stored procedures, and statistics, from one Teradata Database system to another Teradata Database system. Tables and data returned by views can be copied between systems. View definitions cannot be copied.

In addition to tables and statistics, the following database objects associated with tables can be copied with the tables, but not by themselves:
  • Hash indexes
  • Join indexes
  • Triggers
Dual-active support of active copying between two systems is provided through the graphical, REST, and command-line interfaces of Data Mover, which allows you to:
  • Establish systems to enable copying, or recover systems to re-enable copying.
  • Copy a large volume of data from one Teradata Database system to another on a regularly-scheduled basis.
  • Perform a partial copy of tables from a source Teradata Database system to a target system.

In the command-line interface, you can use commands to define jobs, run jobs, and edit jobs. If Teradata Viewpoint is installed in your environment, you can access the functionality of Data Mover in a user-friendly graphic interface.

RESTful API is available with Data Mover and supports all job related commands using the REST API. For more information, see Data Mover RESTful API.

If Teradata Ecosystem Manager is installed in your environment, it can be used to monitor and control Data Mover.

For information about objects supported between databases, see Objects Supported During Moves Between Databases.