Export Database (File Menu)

The schema database export function generates either an SQL or an XML file of the database contents. Both formats present a dialog prior to the actual export process.

SQL Database Export

The SQL format creates a text file that contains SQL statements that can restore a database or transfers the structure and contents of a database into another database.

SQL Database Export Dialog Items

Schema

The currently active schema database name is displayed for confirmation.

Export File

The required name of the SQL file to be generated. A browse button allows easy navigation and file name specification.

Export

This list controls the views and files to be output by the export process. Checked views and files will be output. Buttons are available to set or clear all items in a category.

Once the export is complete, the file may be archived for security or used in another database product to reconstitute the structure and data.

XML Database Export

The XML format creates a text file that contains XML formatted data that can be accessed by other programs.

XML Database Export Dialog Items

Schema

The currently active schema database name is displayed for confirmation.

Export File

The required name of the XML file to be generated. A browse button allows easy navigation and file name specification.

Tables

Allows views or SQLIO Files to be exported.

Once the export is complete, the file may be archived for security or import into another database.