Copy Schema

Overview dataPro can be used to copy table structure to create new tables. 1. Select the originated table 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 Schema" from the Database popup menu A new table will be created with the same table structure as the original table. dataPro copies table schema automatically only to the same database type. If the database type is different from the database type of original table dataPro will display Create New Table Wizard dialog box. The Wizard allows you to make changes to the original table schema according to the destination database type standards.

Create new table Dialog box Create table Dialog box can be used to copy table schema from one database to another, for example from the Oracle database to the SQL Server database. Create new table Dialog box allows you to visually create tables in any database supported by dataPro. Due to differences in database implementations Create Table Dialog box does not support creating foreign keys as a part of the wizard functionality. But you can always use SQL String editor to add foreign key to the create table statement. To change column data type highlight the column using wizard view. Right mouse click will bring up the menu with data types supported by the database. Double click on the column row will fill New Column part of the Wizard with the column data. User can make changes to the column description and add it to the table or replace highlighted column with the new data.