6. Export metadata

This tool extracts metadata of selected database into SQL script, execution of which allows you to create a duplicate of that database.

_images/export_metadate.png — Fig. 6.1 Export metadata

Source database is the database whose metadata needs to be extracted.

The Attributes block is a list of database elements that need/ do not need to be considered when exporting.

The Parameters block is a list of conditions that affect the extraction of metadata and the generation of the SQL script that creates the selected database:

Ignore comments - consider comments when exporting;
Ignore calculated fields - consider calculated fields when exporting;
Ignore PK/FK/UK/CK - consider restrictions when exporting.

You can view results of metadata export in Output, View, and SQL tabs. Output tab lists the items whose metadata has been extracted. View tab displays the extracted items that will be created when the generated script is executed. SQL tab contains the generated SQL script.