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

Teradata® Data Mover User Guide - 20.01

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Data Mover
Release Number
20.01
Published
November 2023
Language
English (United States)
Last Update
2023-12-05
dita:mapPath
hlv1700545853003.ditamap
dita:ditavalPath
mpm1591127278842.ditaval
dita:id
don1467241476387
Product Category
Analytical Ecosystem

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 Vantage system to another Vantage 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 system to another on a regularly-scheduled basis.
  • Perform a partial copy of tables from a source 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.