dataPro can be used to copy database objects as tables, views, triggers, stored procedures and functions beetwen databases.

1. Select the original object in the database/table tree view.
2. Select "Copy" from the Database popup menu
3. Select destination database from the database/table tree view.
4. Select "Paste" from the Database popup menu

A new object will be created.

Views, triggers, stored procedures and functions can be copied only beetwen databases with the same database type.

dataPro converts table schema automatically to any database type.

There are two ways of converting table schema from one database to another:

Copy Database dialog box will show the contain of the selected database if user selects to copy the entire database.

The Copy Database dialog allows you to mark database objects you wish to transfer.

Force NULL option controls the way empty fields are populated in target table. If this option is selected, all empty fields will be inserted as a NULL, otherwise, empty character fields will be inserted as '' instead of NULL.