Vive Corp.
 
 

Documentation

 
Services Products Support Downloads Contact Us About Us Site map

 
 

dataPro

 
 
Prev: Copy and Paste operationsNext: Import Text files to the Database

Copy Data

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

Copy Data

    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.


Prev: Copy and Paste operationsNext: Import Text files to the Database
 
     

 
Services | Products | Support | Downloads | Contact Us | About Us | Site Map
Copyright 1998-2009 Vive Corp. All rights reserved.