Export

Database can be exported using the Export Wizard. It writes SQL create, alter and insert statements according to the tables to a plain file per table or into a zip file optionally.

Import

The import wizard reads files created by the export wizard and executes the contained statements in a sequence that should prevent errors related to referential constraints. Files are placed into a directory structure that is mirroring the element structure (schema/catalog) of the export source and that can be used to create a similar structure in the target database.

If a table that should be imported already exists, a dialog prompts the user to decide how to handle the situation. There are the following options supported:
  1. Cancel the entire process
  2. Skip the table
  3. Leave the table and content as it is and insert the content found in the file to import
  4. Clear the table and insert the content from the file
  5. Remove the table, create it using the creation statement found in the import file and insert the content

Options:
Create Indexes
If this is turned on, DbEdit will create all indexes for the selected tables.
Create Constraints
If this is turned on, DbEdit will create the foreign key constraints for selected table after the content is inserted (if that option is turned on).
Insert Data into Tables
If this turned on, then the data is imported by executing appropriate insert statements.


Import Wizard

Data Type Mapping

This page lets you customize the data type mapping used to create the imported statements. All mapping entries that are marked as a warning are not recognized by the currently selected impor target. You should change them step by step by choosing an entry from the combo box that will be enabled if you click the mapped type you want to specify.




Legal Notice