Advanced Properties dialog

The Advanced properties dialog provides options for extracting and generating database schema information.


This figure shows an example of properties that can be changed with the Advanced Properties dialog.

Figure 1. Advanced Properties dialog

Extraction

Case sensitivity
Specify how case in database object names should be handled.Case sensitive: case won't be changed on database objects, Lower case: database object names will be converted to lower case, Upper case : database object names will be converted to upper case.
Import system tables
Check this box to include system tables in the schema.
Ignore errors
Specify that conversion errors should be ignored. If this option is unchecked, the extraction will stop as soon as an error occurs (for example, if a table column has an unsupported type.)
Conversion method
Select the type of conversion you wish for the specific data types; the default choice is Type A.

Generation

Database schema
Name of selected meta-schema file.
Target database
Specify the database to use in the script.
Options
Specify whether to include primary keys, foreign keys, and indexes in the script.