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, 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.
 Please note: 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


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 30, 2018, 12:23:32 PM by vera.bonda
 
© 1999-2018, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement