Exporting Database objects

You can export the complete database or chosen objects by using the export dialog, which can be opened from the application menu.

The export dialog contains additional options that you cna use to customize the export. You can select one or more tables to be included in the export, including their data, or either the structure or the data. You can also select to export the stored procedures, user defined functions, views and triggers in the output. The export can take a considerable amount of time depending on the number of exported items and the size of export data in the database. The output is provided in the form of a sql file, that can be used to import all the exported data into a database without any modification.

If the option ‘Set auto-increment values to NULL’ is checked on the export dialog, it will generate queries with all auto-increment field values to NULL. This option is NOT RECOMMENDED if your database contains foreign key definitions, as import will usually fail with errors due to foreign key contraints. Also, if your database contains master/details relationship tables with data, you should uncheck this option to make sure your data import works without any errors later on.