Export and Import Tables

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:

Cancel the entire process
Skip the table
Leave the table and content as it is and insert the content found in the file to import
Clear the table and insert the content from the file
Remove the table, create it using the creation statement found in the import file and insert the content

Options:

Remove tables before data import	If this is turned on, in a first pass DbEdit tries to remove the tables in the selected target container that's names match the file names from the selected source. If you not explicitly turn on the 'Don't warn before removing tables' option, you must confirm each deletion.
Clear tables before data import	If this is turned on, in the first pass DbEdit tries to clear the tables in the selected target container that's names match the file names from the selected source. If you not explicitly turn on the 'Don't warn before clearing tables' option, you must confirm each deletion.
Process alter table statements after insertion statements	If this turned on, then the data insertion is done in the second pass and the altering of tables is done in the third pass. Else the altering is executed before data insertion.

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.