16.00 - Copying Table Data Between Teradata Databases - Teradata Studio

Teradata Studio User Guide

Teradata Studio
March 2017
User Guide
The Copy Object Wizard copies Teradata table data from one Teradata Database to another.
  1. Open the Data Source Explorer and navigate to the Tables folder in a Teradata Database.
  2. Right-click a table object and select Data > Load Data.
  3. In the Data Transfer Wizard, select Teradata as the Source Type and click Launch.
  4. Select the table to copy by specifying Source information:
    1. Select from the list the Teradata Connection Profile that contains the table to copy.
    2. Select the Database that contains the table object.
    3. Select the Table to copy.
  5. Click Next.
  6. [Optional] Specify which columns are to receive data from the source table, and select whether to append the data or replace existing data in the destination table.
  7. In Job Name, accept the default name or rename the Copy Object job.
  8. Click Next
  9. In SQL Summary, review the generated Data Definition Language (DDL) script for the transfer. Some objects, such as macros, display blank.
  10. [Optional] If you want to save the DDL script, click Save DDL to open the SQL Save dialog and specify a file location and name.
  11. Click Finish to run the transfer job. The Copy Object Wizard prompts you that the object created successfully or failed.
  12. If successful, monitor the data transfer operation in the Transfer Progress View.
  13. Review details about the data transfer operation in the Transfer History View.