Copy Data

Overview dataPro can be used to copy data from one table to another. 1. Select the originated table in the database/table tree view. 2. Select "Copy" from the Database popup menu 3. Select destination table from the database/table tree view. 4. Select "Paste Data" from the Database popup menu 5. Copy Data dialog box will appear 6. If you checked Stop on Error check box the data transfer will stop after the first SQL error. Otherwise all errors will be ignored. 7. Click Start button All rows from one table will be copied to another.

Limitations Data transfer is performed based on the following rules: 1. Tables names do not have to be the same. 2. Data from the particular column in the table is transferred only if the column name in the originated table matches the column name in the destination table. 3. All other columns are ignored. 4. Column type does not matter. dataPro will attempt to perform the appropriate data conversion. 5. If the column weight in the destination table is less than the column weight in the originated table the data will be truncated.