16.00 - Copying Objects Using the Data Transfer Wizard - Teradata Studio

Teradata Studio User Guide

prodname
Teradata Studio
vrm_release
16.00
created_date
March 2017
category
User Guide
featnum
B035-2041-126K
You can copy Teradata table objects in the Data Source Explorer to another database.
  1. Open two Connection Profiles, one for the source database system and another for the destination system.
  2. Open the Data Source Explorer.
  3. Navigate to the database and Tables folder to which you want to copy data from another table.
  4. Right-click Tables and select Teradata > Data Transfer.
  5. Select Teradata as the Source Type.
  6. Verify the Destination platform is correct. It should read Teradata.
  7. Click Launch.
  8. Verify the Destination information is correct. If it is not correct, click Cancel and return to step 3 to select a different destination database.
  9. Select the Teradata Connection Profile for the database that contains the data you want to copy.
  10. Select from the Database list the specific database that contains the table data.
  11. Select from the Table list the table that contains the data to be copied.
  12. Click Next.
  13. Verify the Source and Destination information is correct.
  14. Select from these options:
    Option Description
    Copy Data Copies the data with the table.
    Lock Table Locks the table during the Copy Object operation.
  15. Click Next.
  16. Identify the specific data you want to include in the data transfer operation using one of the following:
    Option Description
    De-select columns you do not want to include Un-check the box beside the table column you do want transferred.
    Filter data Use the filter list to select the filter type and type a value on which to filter the data. For example, for PhoneNo if you select the filter "equal to" (=) and enter the value 315*, only phone numbers that begin with area code 315 are transferred. The default is None.
  17. Review the Job Name information and if needed, edit the name.
  18. Click Next.
  19. In SQL Summary, review the generated Data Definition Language (DDL) script for the transfer. Some objects, such as macros, display blank.
  20. [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.
  21. Click Finish to run the transfer job. The Copy Object Wizard prompts you that the object created successfully or failed.
  22. If the transfer operation is successful you can monitor the data transfer job in the Transfer Progress View or review details about the data transfer job in the Transfer History View.