When you drag and drop a table from the Data Source Explorer to the Data Lab View, the Copy Wizard displays the name of the source and destination tables in the Copy Table dialog.
- 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 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. If you want to create an empty table, do not select this option. Lock Table Locks source and destination tables during the data transfer.