Ispirer Ispirer
 

Differences

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

Link to this comparison view

sqlways:command-line:sqlways-ini:ddl-section [August 15, 2018, 02:04:15 PM]
alexandr.kirpichny
sqlways:command-line:sqlways-ini:ddl-section [September 04, 2018, 12:39:56 PM] (current)
alexandr.kirpichny
Line 56: Line 56:
 | **REMOVE_VAR_PREFIX** | This option controls the way the source variable prefix like "@" will be replaced from MS SQL Server, Sybase ASE databases inTO other target databases. In case the option is set to "Yes", the SQLWays will just remove the variable prefix and variable name will be without any additional prefixes. If the option = "No", the SQLWays will remove source prefix with the prefix defined in the VAR_PREFIX option. Default prefix that will be used is "v_". User can specify its own prefix that will be used in conversion. \\ Possible values - Yes, No. \\ Default value - Yes. | | **REMOVE_VAR_PREFIX** | This option controls the way the source variable prefix like "@" will be replaced from MS SQL Server, Sybase ASE databases inTO other target databases. In case the option is set to "Yes", the SQLWays will just remove the variable prefix and variable name will be without any additional prefixes. If the option = "No", the SQLWays will remove source prefix with the prefix defined in the VAR_PREFIX option. Default prefix that will be used is "v_". User can specify its own prefix that will be used in conversion. \\ Possible values - Yes, No. \\ Default value - Yes. |
 | **VAR_PREFIX** | This option defines what variable prefix will be used in variables when migrating from such databases as MS SQL Server and Sybase ASE. In this option a user can specify its own prefix. \\ Default value - "v_". | | **VAR_PREFIX** | This option defines what variable prefix will be used in variables when migrating from such databases as MS SQL Server and Sybase ASE. In this option a user can specify its own prefix. \\ Default value - "v_". |
 +| **USE_CHAR_LENGTH** | When migrating tables from Oracle to PostgreSQL, Greenplum or Redshift direction, 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, then you need to set this option to "Yes" and our tool will use information from ALL_TAB_COLUMNS from "CHAR_LENGTH" column. \\ Possible values - "Yes", "No" or Empty. \\ Default value - "No" or Empty. |
  
 **Example**: **Example**:
sqlways/command-line/sqlways-ini/ddl-section.txt · Last modified: September 04, 2018, 12:39:56 PM by alexandr.kirpichny
 
© 1999-2018, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement