Table of Contents
Ispirer Website
Ispirer Toolkit Overview
Free Trial
Generation Options
| Option name | Descriptions |
|---|---|
| Generate DDL | If checked, DDL statement will be created for each table. |
Generate DDL
If this option is checked, a DDL statement will be created for every table. If not - data import scripts and SQL scripts for the remained objects like views, procedures and etc. will be generated.
Generate IDENTITY Columns
This option controls the way identity values are generated in a target Oracle database. This option may be set to the values below:
- “ALWAYS” - values in IDENTITY columns will be generated always automatically. And in table definition will be used “generated always as IDENTITY” option.
- “ON NULL” - values in in IDENTITY columns will be generated only instead of nulls. And in table definition will be used “GENERATED BY DEFAULT ON NULL AS IDENTITY” option.
- “DEFAULT” - values in in IDENTITY columns will be generated by default. And “GENERATED BY DEFAULT AS IDENTITY” will be used in table definition in Oracle.
NOTICE: This option works only for Oracle as a target database.
If you have some additional questions or face some difficulties, please contact our support team and provide a detailed description of your issue: support@ispirer.com