Overview
dataPro can be used to copy data from one table to another, even if source and destination table schemas are different.
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. Copy Data dialog will allow you to map table columns before copying by doble clicking on the selected column. You can change only TO TABLE columns.
Change column name to "-" if you do not want the data from the specific column to be transfered.
7. If you check Stop on Error check box, the data transfer will stop after the first SQL error,
otherwise, all errors will be ignored.
8. If you check Force NULL option dataPro will NULL to insert empty fields. Otherwithe it will insert '' into character fields.
9. Click Start button.
All rows from one table will be copied to another table.
|