Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Migration Product Page Request SQLWays

Generation options

Option name Descriptions
Generate DDL If checked, DDL statement will be created for each table.

Generate DDL

If this option is checked DDL statement will be created for each table. If not - the data import scripts and the SQL scripts for the rest objects like views, procedures and etc. will be generated.

Generate IDENTITY Columns

This option controls how the identity values will be generated in 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.
 Please note: This option works only for Oracle as a target database.

If you will have some additional questions or face with some difficulties please contact our support team and provide detailed description of the case you faced with: support@ispirer.com


Ispirer Home Page Ispirer SQLWays Migration Product Page Request SQLWays

sqlways/users-guide/wizard/specify-ddl-data/table_options/ddl_options/sql_script.txt · Last modified: May 07, 2018, 03:15:36 PM (external edit)
 
© 1999-2018, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement