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 [October 05, 2018, 11:44:24 AM]
darya.prikhodkina
sqlways:command-line:sqlways-ini:sql-server-section [October 26, 2018, 11:19:58 AM] (current)
darya.prikhodkina [Sqlways.ini File - Section [MSSQL]]
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 is 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 is 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** | Applicable when during the migration from Firebird to MSSQL global data type mapping is used to change conversion of TIMESTAMP data type to DATETIMEinstead of DATETIME2 and when in FIREBIRD database TIMESTAMP columns contain dates before "January 1, 1753", for example "May 15, 1555". There are cases when such dates cannot be inserted into DATETIME columns in MSSQL. So this option can be used to check the dates stored in such columns. And if the tool sees that value may not be inserted in DATETIME column, then SQLWays will change it to the "January 1, 1753" value. For PostgreSQL to MSSQL direction this option checks the range and also cuts the millisecond part of date. \\ Possible values - "Yes", "No" or Empty. Default value - "No" or Empty. |+| **CHECK_DATETIME_DATA** | Applicable when during the migration from Firebird to MSSQL global data type mapping is used to change conversion of TIMESTAMP data type to DATETIME instead of DATETIME2 and when in FIREBIRD database TIMESTAMP columns contain dates before "January 1, 1753", for example "May 15, 1555". There are cases when such dates cannot be inserted into DATETIME columns in MSSQL. So this option can be used to check the dates stored in such columns. And if the tool defines that a certain value may not be inserted in DATETIME column, SQLWays will change it to "January 1, 1753" value. For PostgreSQL to MSSQL direction this option checks the range and also cuts 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 less or equal to 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 less or equal to 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 less or equal to 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 less or equal to 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: October 26, 2018, 11:19:58 AM by darya.prikhodkina
 
© 1999-2019, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement