Teradata Studio's Copy Objects via Drag and Drop
Teradata Studio's Copy Object Wizard allows users to copy objects by simply dragging the object from the Data Source Explorer tree and dropping it into the destination node in the Transfer View tree. Often users have created objects in their test database and wish to copy it to production, or copy objects from production into their test data lab environment. Database objects can be copied within the same database server or to a different database server. You can copy more than one object at a time by selecting multiple objects from the Data Source Explorer and dragging them to the Transfer View tree. Due to the external code location, External Stored Procedures and User Defined Functions can not be copied.
The Copy Object Wizard also allows you to filter out columns or column data when copying tables. You can also copy table data to an existing table, providing a map of source columns to destination columns.
To begin copying objects, start Teradata Studio and create connection profiles to your source and destination database systems.
There are two ways to invoke the Copy Object Wizard, drag and drop from the Data Source Explorer to the Transfer View or via the Data Transfer Wizard for copying table objects.
Copy via Drag and Drop
The Copy Object Wizard can be invoked by dragging a Teradata object from the Data Source Explorer and dropping it on the destination Teradata database in the Transfer View.
The Copy Object Wizard will display a confirmation screen showing the Source and Destination systems. If the name is not valid for the destination, an error message is displayed and you can edit the name field.
Click Next to view the generated SQL statement that will be executed to copy the database object.
Click Finish to execute the generated SQL statement. If mulitple objects are dragged to the destination, an intermediary dialog is displayed as the objects are copied one at a time.
Copy via Data Transfer Wizard
The other way to invoke the Copy Object Wizard is via the Data Transfer Wizard. For example, you can select a Teradata table in the Data Source Explorer, right click and choose Data>Export.... In the Data Transfer Wizard, choose the Destination Type as Teradata and click Launch. This will launch the Copy Object Wizard to copy the table object. NOTE: You can also select the Data>Load... option and choose the Source Type as Teradata to launch the Copy Opject Wizard and copy another Teradata table's data into the selected table.
Next, select the connection profile and destination database for where you wish to copy the table to. You can copy the table as a 'New Table', or copy the table data to an existing Teradata table. If you wish to create a new table, check the 'Create New Table' option, else select the destination table you want to copy the data to.
The Copy Object Wizard will display a confirmation screen showing the Source and Destination systems. If the name is not valid for the destination, an error message is displayed. Click Next to filter columns and column data.
If choosing the 'New Table' option, you can filter columns and column data.
Click Next to view the SQL that is generated for the new table and copying its data.
Or, if you chose to copy the table to an existing Teradata table, you will be required to map the source columns to the columns of the destination table. You can also choose whether to append or replace the data. If you choose to replace the data, the current data will be deleted. You will be prompted to confirm that you want the Copy Object Wizard to delete the table data.
Click Next to view the SQL that is generated for selecting the data for the data copy.
Click Finish to complete the Copy. If you are copying table data, a Data Transfer job is created to perform the data copy. As with data load, the status of the Data Transfer job is displayed in the Transfer Progress View. When the job has completed, an entry is placed in the Transfer History View.
Transfer History View
The Transfer History View displays the information about the copy data transfer, such as the name (given by the Copy wizards), timestamp, source and destination systems, status, duration, rows transfered (if known), note, and summary. This information is stored in an embedded Derby database. You can sort and filter the rows and columns, edit the name or note. The data transfer job can be re-executed by selecting the entry and pressing the Re-execute toolbar button. The output of the transfer data job is displayed by pressing the Job Output button.