When you drag and drop a table from the Data Source Explorer both the Copy source and destination Teradata Database names display in the Copy Table screen of the Copy Object Wizard.
- Source Database
- The source information includes the names of the Connection Profile, Database, and Table from which the data is copied.
- Destination Database
- The destination information includes the names of the Connection Profile, Database, and Table to which the Copy Object Wizard copies the data.
- Instructions for Copy Job
- You can specify these options for the Copy job:
Option Description Copy Data Creates the destination table and copies the source data to the new table. Lock Table Locks source and destination tables during the data transfer.