Ispirer Ispirer
 

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

sqlways:users-guide:wizard:specify-ddl-data [July 27, 2018, 01:04:03 PM]
alexandr.kirpichny [Data Options]
sqlways:users-guide:wizard:specify-ddl-data [December 27, 2018, 01:01:39 PM] (current)
alexandr.kirpichny [Convert indexes]
Line 79: Line 79:
    *[[sqlways:users-guide/wizard/specify-ddl-data/table_options/ddl_options/global_type_mapping| Global Data Type Mapping]]    *[[sqlways:users-guide/wizard/specify-ddl-data/table_options/ddl_options/global_type_mapping| Global Data Type Mapping]]
    *[[sqlways:users-guide/wizard/specify-ddl-data/table_options/ddl_options/sql_script| Generation options]]    *[[sqlways:users-guide/wizard/specify-ddl-data/table_options/ddl_options/sql_script| Generation options]]
 +   *[[sqlways:users-guide/wizard/specify-ddl-data/table_options/ddl_options/table_options| Table options]]
  
 ====== Global Data Type Mapping ====== ====== Global Data Type Mapping ======
Line 96: Line 97:
 | [[specify-ddl-data#generate ddl|Generate DDL]] | If checked, DDL statement will be created for each table. | | [[specify-ddl-data#generate ddl|Generate DDL]] | If checked, DDL statement will be created for each table. |
  
-====== Generate DDL ======+===== 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. 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.
Line 114: Line 115:
 If you have some additional questions or face some difficulties, please contact our support team and provide a detailed description of your issue: [[[email protected]]] If you have some additional questions or face some difficulties, please contact our support team and provide a detailed description of your issue: [[[email protected]]]
  
----- 
  
 +====== Table options ======
 +
 +{{:sqlways:users-guide:wizard:tab_options.png?700|}}
 +
 +
 +
 +== Change Column Name Case ==
 +
 +Defines the case of the column names.
 +
 +== Use Constraint names of the source database ==
 +
 +This option will use the same constraint names as in the source database. Otherwise, constraint names will be skipped. 
 +
 +== Convert default values ==
 +
 + This option converts default values for columns. If this option is switched off, then conversion of default values will be skipped.
 +
 +== Convert identity columns ==
 + 
 + This option converts identities. If this option is switched off, then conversion of identities will be skipped.
 +
 +== Force NOT NULL constraints for columns that make up a primary key ==
 +
 + This option is used to set the NOT NULL constraints in the CREATE TABLE statement for columns making up a primary key. Some databases ( Sybase, Access e.g.) allow to not specify the NOT NULL constraints for primary key columns explicitly when creating a table, and they change columns to NOT NULL when adding a primary key. Other databases (IBM DB2, Microsoft SQL Server, MySQL e.g.) require primary key columns to be created with NOT NULL constraints before adding a primary key.
 +
 +== Remove NOT NULL constraints from all columns except primary key columns ==
 +
 + If checked the NOT NULL constraints for all columns except primary key columns in the target database are removed.
 +
 +== Convert CHECK constraints ==
 +
 + This option defines whether check constraints should be converted. If unchecked, check constraints will be skipped.
 +
 +== Convert Unique constraints ==
 +
 + This option defines whether unique constraints should be converted. If unchecked, unique constraints will be skipped.
 + 
 +== Convert indexes ==
 +
 +This option defines the types of the indexes that will be converted by the SQLWays tool. __//ALL//__ – means that all indexes will be converted. __//Unique//__ – means that only unique indexes will be converted. __//None//__ – means that all the indexes will not be converted.
 +\\ \\
 ====== Data Options ====== ====== Data Options ======
  
sqlways/users-guide/wizard/specify-ddl-data.1532696643.txt.gz · Last modified: July 27, 2018, 01:04:03 PM by alexandr.kirpichny
 
© 1999-2019, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement