Ispirer Ispirer
 

Differences

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

Link to this comparison view

sqlways:command-line:sqlways-ini:sql-server-section [July 31, 2018, 11:57:03 AM]
alexandr.kirpichny
sqlways:command-line:sqlways-ini:sql-server-section [September 03, 2018, 02:18:17 PM] (current)
alexandr.kirpichny
Line 24: Line 24:
 | **DOUBLE_SIZE_CHARACTERS_DATA_TYPES** | If this option is set to "Yes", SQLWays will double the size of the character columns in the converted tables. \\ Possible values - "Yes", "No" or Empty. Default value - "No" or Empty. | | **DOUBLE_SIZE_CHARACTERS_DATA_TYPES** | If this option is set to "Yes", SQLWays will double the size of the character columns in the converted tables. \\ Possible values - "Yes", "No" or Empty. Default value - "No" or Empty. |
 | **ORIGINAL_LOGIN_WITHOUT_DOMAIN** | This option controls the way how Informix function USER will be converted to MS SQL Server. If this option is set to "Yes", SQLWays will generate SWF_ORIGINAL_LOGIN() function that will remove domain name from the result returned by ORIGINAL_LOGIN() function. If this option is empty or set to "No", ORIGINAL_LOGIN() function will be used. \\ Possible values - "Yes", "No" or Empty. Default value - "No" or Empty. | | **ORIGINAL_LOGIN_WITHOUT_DOMAIN** | This option controls the way how Informix function USER will be converted to MS SQL Server. If this option is set to "Yes", SQLWays will generate SWF_ORIGINAL_LOGIN() function that will remove domain name from the result returned by ORIGINAL_LOGIN() function. If this option is empty or set to "No", ORIGINAL_LOGIN() function will be used. \\ Possible values - "Yes", "No" or Empty. Default value - "No" or Empty. |
-| **CHECK_DATETIME_DATA** | When during migration from Firebird to MSSQL global data type mapping is used to change conversion TIMESTAMP data type to DATETIME, instead of DATETIME2the case when in FIREBIRD database in TIMESTAMP columns stored dates before “January 1, 1753”, for example “May 15, 1555”. And such dates could not be inserted into DATETIME columns in MSSQL. For such cases the option that will check dates stored in such columns can be used. And if the tool will see that value may not be inserted in DATETIME column may appear, then SQLWays will change it to the “January 1, 1753” value. \\ Possible values - "Yes", "No" or Empty. Default value - "No" or Empty. |+| **CHECK_DATETIME_DATA** | When migrating to MSSQL, and global data type mapping is used to change conversion of TIMESTAMP data type to DATETIME, instead of DATETIME2. This option will check the data that will be loaded into the DATETIME column and if required modify it in a proper way. For example in FIREBIRD database in TIMESTAMP columns may be stored dates before “January 1, 1753”, for example “May 15, 1555”. And such dates could not be inserted into DATETIME columns in MSSQL. For such cases the option that will check dates stored in such columns can be used. And if the tool will see that value may not be inserted in DATETIME column may appear, then SQLWays will change it to the “January 1, 1753” value. For PostgreSQL to MSSQL direction this option will check the range and also cut the millisecond part of date. \\ Possible values - "Yes", "No" or Empty. Default value - "No" or Empty. |
 | **MAP_CHAR_TO_NCHAR** | If this option is set to Yes, all CHAR columns with length lower or equal 4000 will be converted to NCHAR in MSSQL. \\ Possible values - "Yes", "No" or empty. Default value - "No" or empty. | | **MAP_CHAR_TO_NCHAR** | If this option is set to Yes, all CHAR columns with length lower or equal 4000 will be converted to NCHAR in MSSQL. \\ Possible values - "Yes", "No" or empty. Default value - "No" or empty. |
 | **MAP_VARCHAR_TO_NVARCHAR** | If this option is set to Yes, all VARCHAR columns with length lower or equal 4000 will be converted to NVARCHAR in MSSQL. \\ Possible values - "Yes", "No" or empty. Default value - "No" or empty. | | **MAP_VARCHAR_TO_NVARCHAR** | If this option is set to Yes, all VARCHAR columns with length lower or equal 4000 will be converted to NVARCHAR in MSSQL. \\ Possible values - "Yes", "No" or empty. Default value - "No" or empty. |
sqlways/command-line/sqlways-ini/sql-server-section.txt · Last modified: September 03, 2018, 02:18:17 PM by alexandr.kirpichny
 
© 1999-2018, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement