16.00 - Dropping Objects on Transfer View - Teradata Studio

Teradata Studio User Guide

Teradata Studio
March 2017
User Guide

Objects can be dragged from the Data Source Explorer and dropped into the Transfer View and back to copy from one database to another.

The following instructions are specific to dragging from Data Source Explorer and dropping into the Transfer View.

  1. Open two Connection Profiles, one for the source database system and another for the destination database system of the transfer.
  2. Open the Data Source Explorer and navigate to the Teradata Database object you want to copy to another system.
  3. Open the Transfer View by opening the Data Transfer perspective or selecting Window > Show View > Transfer View.
  4. In the Transfer View, use the Teradata system to which you want to copy the object from the Select Profile list. If the system you want is not listed, return to the Data Source Explorer and right-click Database Connections to select New and connect to the correct profile.
  5. Select the Data Source Explorer object and drag and drop it into the Transfer View pane to launch the Copy Object Wizard. Be sure to drop the object on a folder of the same type or on a database/user folder.
  6. Verify that the information shown for Source and Destination systems is correct, and the object to be copied is correct. The name of the source object is used by default to identify the destination object.
  7. [Optional] If copying a table object, select from these options:
    Option Description
    Copy Data Copies the data with the table.
    Lock Table Locks the table during the Copy Object operation.
  8. Click Next.
  9. [Optional] If you are copying a table, select one of these methods to transfer the data:
    Option Description
    Transferring data to a new table Select each column you want transferred. You can filter data by specifying filter values for individual columns. The default is None.
    Transferring data to an existing table 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.
  10. In Job Name, accept the default name or rename the Copy Object job.
  11. Click Next.
  12. In SQL Summary, review the generated Data Definition Language (DDL) script for the transfer. Some objects, such as macros, display blank.
  13. [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.
  14. Click Finish to run the transfer job. The Copy Object Wizard prompts you that the object created successfully or failed.
  15. 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.