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 Teradata systems and Hadoop systems. View definitions cannot be copied.
- Hash indexes
- Join indexes
- Triggers
- 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.