You can copy Teradata table objects in the Data Source Explorer to another database.
- Open two Connection Profiles, one for the source database system and another for the destination system.
- Open the Data Source Explorer.
- Navigate to the database and Tables folder to which you want to copy data from another table.
- Right-click Tables and select .
- Select Teradata as the Source Type.
- Verify the Destination platform is correct. It should read Teradata.
- Click Launch.
- Verify the Destination information is correct. If it is not correct, click Cancel and return to step 3 to select a different destination database.
- Select the Teradata Connection Profile for the database that contains the data you want to copy.
- Select from the Database list the specific database that contains the table data.
- Select from the Table list the table that contains the data to be copied.
- Click Next.
- Verify the Source and Destination information is correct.
-
Select from these options:
Option Description Copy Data Copies the data with the table. Lock Table Locks the table during the Copy Object operation. - Click Next.
-
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. - Review the Job Name information and if needed, edit the name.
- Click Next.
- In SQL Summary, review the generated Data Definition Language (DDL) script for the transfer. Some objects, such as macros, display blank.
- [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.
- Click Finish to run the transfer job. The Copy Object Wizard prompts you that the object created successfully or failed.
- 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.