Extract Metadata Expert

Using the Extract Metadata Expert you can extract the database metadata and table data to the SQL script for future executing.

To call the expert select the Tools | Extract Metadata menu item.

Select Extract Type

Extract from
Select the database to extract.

Extract type
Select what to extract - database metadata and/or table data.

Script Options
Select where to extract to - to the *.sql file or directly to the SQL Script Editor.

File Name
Set the *.sql file name for the result script.

Select Meta Objects

This page is available only if you select Extract Metadata. Move the tables to extract from the Available to the Selected list.

To move all the objects from one list to another click the double arrow buttons ( >> or << ). To move only the selected objects click the single arrow buttons ( > or < ), drag the selected objects or double-click the required object. To select multiple objects, hold down the Shift or Ctrl key while selecting the object names.

Check Extract All to extract all the database metadata.

Select Data Objects

This page is available only if you select Extract Data. Select the database tables to extract their data by moving them from the Available Tables list to the Selected Tables.

To move all the tables from one list to another click the double arrow buttons ( >> or << ). To move only the selected tables click the single arrow buttons ( > or < ), drag the selected tables or double-click the required table. To select multiple tables, hold down the Shift or Ctrl key while selecting the table names.

Set Extract Options

   Generate DROP IF EXISTS statements
Generates the DROP IF EXISTS statement for the selected metadata.

Data Options
Defines the number of records to insert the COMMIT statement after.

   Load script to Script Editor
Check this option to extract metadata and data directly to SQL Script.

You can save the extract configuration (extract type, meta and data objects, extract options) for future use as a template. Just click button Save Template on the left panel and set the template name. Next time you will be able to configure your extract quickly by clicking the button Load Template and choosing the appropriate previously saved template.

When you are done, click Extract.

See also:

Export Data As INSERT Dialog