Differences
This shows you the differences between two versions of the page.
sqlways:command-line:sqlways-ini:ddl-section [February 08, 2019, 12:06:07 PM] – darya.prikhodkina | sqlways:command-line:sqlways-ini:ddl-section [May 31, 2023, 05:28:08 PM] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 1: | Line 1: | ||
\\ | \\ | ||
- | [[http:// | + | [[https:// |
- | [[http:// | + | [[https:// |
- | [[http:// | + | [[https:// |
====== Sqlways.ini File - Section [DDL] ====== | ====== Sqlways.ini File - Section [DDL] ====== | ||
Line 22: | Line 22: | ||
| **DROP_TABLE_CASCADE_CONSTRAINTS** | If Yes is specified, the CASCADE CONSTRAINTS option is generated in the DROP TABLE statement. Currently this option is supported by Oracle only. \\ This option is available only if the target database is Oracle and GENERATE_DROP_TABLE is set to Yes. The default value is No. | | | **DROP_TABLE_CASCADE_CONSTRAINTS** | If Yes is specified, the CASCADE CONSTRAINTS option is generated in the DROP TABLE statement. Currently this option is supported by Oracle only. \\ This option is available only if the target database is Oracle and GENERATE_DROP_TABLE is set to Yes. The default value is No. | | ||
| **GENERATE_DROP_INDEX** | If Yes is specified, the DROP INDEX statement is generated before each CREATE INDEX statement. The default value is No. Possible values - Yes, No. \\ This option can be helpful when scripts for indexes are re-executed without recreating the table. | | | **GENERATE_DROP_INDEX** | If Yes is specified, the DROP INDEX statement is generated before each CREATE INDEX statement. The default value is No. Possible values - Yes, No. \\ This option can be helpful when scripts for indexes are re-executed without recreating the table. | | ||
- | | **OUTSCHEMA** | Outputs | + | | **OUTSCHEMA** | This option can be used only when " |
- | | **EMPTY_SCHEMA** | for /EMPS option. Possible values - Yes, No. | | + | | **EMPTY_SCHEMA** | This option |
| **COLUMN_NAME_CASE** | This option specifies the case of column names in SQL statements. Possible values - Upper, Lower. If no value is specified, the case of the column names is not changed and column names are used as they are provided in the source database. | | | **COLUMN_NAME_CASE** | This option specifies the case of column names in SQL statements. Possible values - Upper, Lower. If no value is specified, the case of the column names is not changed and column names are used as they are provided in the source database. | | ||
| **USE_CONSTRAINT_NAMES** | If Yes is specified, constraint names of the source database will be used in generated DDL scripts. Otherwise, constraint names will be skipped. The default value is No. Possible values - Yes, No. | | | **USE_CONSTRAINT_NAMES** | If Yes is specified, constraint names of the source database will be used in generated DDL scripts. Otherwise, constraint names will be skipped. The default value is No. Possible values - Yes, No. | | ||
Line 71: | Line 71: | ||
| **SCHEMA_TO_DATABASE** | This option controls schema names conversion for all specified objects for the migration process. If this option is set to " | | **SCHEMA_TO_DATABASE** | This option controls schema names conversion for all specified objects for the migration process. If this option is set to " | ||
| **PARTITION_TABLESPACE** | This option controls whether source partition table tablespaces should be converted or not. When the option is set into " | | **PARTITION_TABLESPACE** | This option controls whether source partition table tablespaces should be converted or not. When the option is set into " | ||
- | | **REMOVE_VAR_PREFIX** | This option controls the way the source | + | | **REMOVE_VAR_PREFIX** | This option controls the way the source |
- | | **VAR_PREFIX** | This option defines which variable prefix will be used in variables when migrating from such databases as MS SQL Server and Sybase ASE. In this option the user can specify his own prefix. \\ Default value - " | + | | **VAR_PREFIX** | This option defines which variable prefix will be used in variables when migrating from such databases as Firebird, |
| **USE_CHAR_LENGTH** | When migrating tables from Oracle to PostgreSQL, Greenplum or Redshift, information about the column length is taken from DATA_LENGTH column from ALL_TAB_COLUMNS system table. This column stores information about the number of bytes of CHAR\VARCHAR2 and NCHAR\NVARCHAR2 columns. And if you need to use the number of characters as a length of CHAR\VARCHAR2 and NCHAR\NVARCHAR2 columns, you need to set this option to " | | **USE_CHAR_LENGTH** | When migrating tables from Oracle to PostgreSQL, Greenplum or Redshift, information about the column length is taken from DATA_LENGTH column from ALL_TAB_COLUMNS system table. This column stores information about the number of bytes of CHAR\VARCHAR2 and NCHAR\NVARCHAR2 columns. And if you need to use the number of characters as a length of CHAR\VARCHAR2 and NCHAR\NVARCHAR2 columns, you need to set this option to " | ||
| **USE_SYSTEM_COLUMN_NAME** | This option allows to use system column names when migrating from DB2 database. \\ Possible values - " | | **USE_SYSTEM_COLUMN_NAME** | This option allows to use system column names when migrating from DB2 database. \\ Possible values - " | ||
Line 83: | Line 83: | ||
| **EXPORT_CONSTRAINTS_FOR_QUERIES** | This option controls whether the constraints should be converted when performing conversion using the queries. \\ Possible values - " | | **EXPORT_CONSTRAINTS_FOR_QUERIES** | This option controls whether the constraints should be converted when performing conversion using the queries. \\ Possible values - " | ||
| **CONVERT_MM_TAB** | This option defines how multi-member tables will be converted from DB2 AS 400 into Microsoft SQL Server database. If this option is set to " | | **CONVERT_MM_TAB** | This option defines how multi-member tables will be converted from DB2 AS 400 into Microsoft SQL Server database. If this option is set to " | ||
- | | **ORACLE_PKG_TO_FN** | This option allows to change package conversion structure logic for Oracle to Greenplum migration direction. By default Oracle packages are converted to sets of Greenplum functions | + | | **ORACLE_PKG_TO_FN** | This option allows to change package conversion structure logic for Oracle to Greenplum migration direction. By default Oracle packages are converted to sets of Greenplum functions |
+ | | **APP_PARAMS_IN_SQL** | This option defines whether the application parameters are used in source Sybase ASE sql code. If this option is set to " | ||
+ | | **VARCHAR_PAR_LEN** | When migrating from Oracle to MySQL, you can specify your own length for VARCHAR parameters in procedures and functions. Specified number will be used as a length of VARCHAR parameters in MySQL procedures and functions. | | ||
+ | | **FK_SELECTED_TABLES_ONLY** | This option defines whether to generate Foreign Key constraints that references tables that were not selected for conversion. If this option is set to " | ||
+ | | **PERCENT_AS_COMMENT** | Sybase ASA database 10 version and lower allows to use " | ||
+ | | **TEMP_TAB_SCHEMA** | This option defines the schema name for temporary tables. It works only when option " | ||
+ | | **CONVERT_SYSTEM_VERSIONED_TABS** | This option defines how to MSSQL convert system versioned tables to PostgreSQL. If this option is set to Yes, then will be generated additional triggers that will emulate the same behavior in PostgreSQL. If this option is empty or set to " | ||
+ | | **OUTER_JOIN_RETURNS_NULLS** | When migrating to Oracle in JOIN is used varchar column that allows NULLs values and this option is set to Yes, then such column will be placed inside NVL function. If this option is empty or set to " | ||
Line 95: | Line 102: | ||
If you have any questions about the supported options or about any features that you may need for your migration project, please contact our technical team: **__[[[email protected]]]__** | If you have any questions about the supported options or about any features that you may need for your migration project, please contact our technical team: **__[[[email protected]]]__** | ||
- | \\ | + | |
- | [[http:// | + | |
- | [[http:// | + | |
- | [[http:// | + |