Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
sqlways:command-line:sqlways-ini:sql-server-section [September 03, 2018, 02:18:17 PM] – alexandr.kirpichny | sqlways:command-line:sqlways-ini:sql-server-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 [MSSQL] ====== | ====== Sqlways.ini File - Section [MSSQL] ====== | ||
Line 8: | Line 8: | ||
^ Option name ^ Description | ^ Option name ^ Description | ||
| **BIN** | Specifies the directory where Microsoft SQL Server utilities like BCP and ISQL are located. | | | **BIN** | Specifies the directory where Microsoft SQL Server utilities like BCP and ISQL are located. | | ||
- | | **TARGET_VERSION** | Specifies the target version of the MSSQL database. If this option is empty the latest MSSQL database version will be used. Note: According to the version number conversion results may be different. | | + | | **TARGET_VERSION** | Specifies the target version of the MSSQL database. If this option is empty the latest MSSQL database version will be used. Note: According to the version number conversion results may differ. | |
| **SERVER_NAME** | Specifies the server name which is used in generated scripts for the BCP and ISQL utilities (Parameter -S of BCP). | | | **SERVER_NAME** | Specifies the server name which is used in generated scripts for the BCP and ISQL utilities (Parameter -S of BCP). | | ||
| **DATABASE** | Specifies the database name which is used in generated scripts for the BCP and ISQL utilities. | | | **DATABASE** | Specifies the database name which is used in generated scripts for the BCP and ISQL utilities. | | ||
- | | **USER** | Specifies the user name which is used in generated scripts for the BCP and ISQL utilities (Parameter -U of BCP). To use this option, the option | + | | **USER** | Specifies the user name which is used in generated scripts for the BCP and ISQL utilities (Parameter -U of BCP). To use this option, |
- | | **PWD** | Specifies the user password which is used in generated scripts for the BCP and ISQL utilities (Parameter -P of BCP). To use this option the option | + | | **PWD** | Specifies the user password which is used in generated scripts for the BCP and ISQL utilities (Parameter -P of BCP). To use this option |
| **TRUSTED_CONNECTION** | Specifies that a trusted connection to Microsoft SQL Server is used in generated scripts for the BCP and ISQL utilities (Parameters -T of BCP and -E of ISQL). When Yes has been chosen in this option, security credentials of the network user are used and a user name (login_id) and a password are not required. Possible values are Yes, No. The default value is No. | | | **TRUSTED_CONNECTION** | Specifies that a trusted connection to Microsoft SQL Server is used in generated scripts for the BCP and ISQL utilities (Parameters -T of BCP and -E of ISQL). When Yes has been chosen in this option, security credentials of the network user are used and a user name (login_id) and a password are not required. Possible values are Yes, No. The default value is No. | | ||
| **MAX_ERRORS** | Specifies the maximum number of errors that can occur before the BCP utility is canceled. Each row that cannot be copied by BCP is ignored and counted as one error (Parameter -m of BCP). The default value is 10. | | | **MAX_ERRORS** | Specifies the maximum number of errors that can occur before the BCP utility is canceled. Each row that cannot be copied by BCP is ignored and counted as one error (Parameter -m of BCP). The default value is 10. | | ||
| **CODE_PAGE** | Specifies a code page of the data in the data file for the BCP utility (Parameter -C of BCP). The following values can be specified for the CODE_PAGE option: \\ * **ACP** - ANSI/ | | **CODE_PAGE** | Specifies a code page of the data in the data file for the BCP utility (Parameter -C of BCP). The following values can be specified for the CODE_PAGE option: \\ * **ACP** - ANSI/ | ||
- | | **int2dec38** | Specifies how to convert Oracle PL/SQL data types INT and INTEGER to Microsoft SQL Server. \\ As the default Oracle PL/SQL data types INT and INTEGER are converted to INT data type. \\ With the option set as YES Oracle PL/SQL data types INT and INTEGER are converted to DECIMAL(38, | + | | **int2dec38** | Specifies how to convert Oracle PL/SQL data types INT and INTEGER to Microsoft SQL Server. \\ By default Oracle PL/SQL data types INT and INTEGER are converted to INT data type. \\ With the option set to YES Oracle PL/SQL data types INT and INTEGER are converted to DECIMAL(38, |
- | | **smallint2dec38** | Specifies how to convert Oracle PL/SQL data type SMALLINT to Microsoft SQL Server. \\ As the default Oracle PL/SQL data type SMALLINT is converted to SMALLINT data type. \\ With the option set as YES Oracle PL/SQL data type SMALLINT is converted to DECIMAL(38, | + | | **smallint2dec38** | Specifies how to convert Oracle PL/SQL data type SMALLINT to Microsoft SQL Server. \\ By default Oracle PL/SQL data type SMALLINT is converted to SMALLINT data type. \\ With the option set to YES Oracle PL/SQL data type SMALLINT is converted to DECIMAL(38, |
| **USE_CONVERT_CHAR_TO_VARCHAR** | This option controls whether to convert CHAR data type to VARCHAR data type while converting to Microsoft SQL Server. The lower limit of CHAR size for which the conversion is required is controlled by **CONVERT_CHAR_TO_VARCHAR** option. The default is No. | | | **USE_CONVERT_CHAR_TO_VARCHAR** | This option controls whether to convert CHAR data type to VARCHAR data type while converting to Microsoft SQL Server. The lower limit of CHAR size for which the conversion is required is controlled by **CONVERT_CHAR_TO_VARCHAR** option. The default is No. | | ||
| **CONVERT_CHAR_TO_VARCHAR** | This option controls the lower limit of CHAR size for which the conversion from CHAR to VARCHAR is required. The optimized default is 20. | | | **CONVERT_CHAR_TO_VARCHAR** | This option controls the lower limit of CHAR size for which the conversion from CHAR to VARCHAR is required. The optimized default is 20. | | ||
| **ROWID_FORMAT** | This option controls the way the ROWID from an Oracle database is being converted to a Microsoft SQL Server database. Possible values are physloc (returns the address of the data in hex format), lockres (returns the address of the data in [File: | | **ROWID_FORMAT** | This option controls the way the ROWID from an Oracle database is being converted to a Microsoft SQL Server database. Possible values are physloc (returns the address of the data in hex format), lockres (returns the address of the data in [File: | ||
- | | **SET_NOCOUNT_IN_SP** | If this option is set into ON, SET NOCOUNT ON statement will be added at the beginning of stored procedures | + | | **SET_NOCOUNT_IN_SP** | If this option is set to ON, SET NOCOUNT ON statement will be added to the beginning of stored procedures |
| **DOUBLE_SIZE_CHARACTERS_DATA_TYPES** | If this option is set to " | | **DOUBLE_SIZE_CHARACTERS_DATA_TYPES** | If this option is set to " | ||
- | | **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 " | + | | **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 " |
- | | **CHECK_DATETIME_DATA** | When migrating | + | | **CHECK_DATETIME_DATA** | Applicable when during the migration from Firebird |
- | | **MAP_CHAR_TO_NCHAR** | If this option is set to Yes, all CHAR columns with length | + | | **MAP_CHAR_TO_NCHAR** | If this option is set to Yes, all CHAR columns with length |
- | | **MAP_VARCHAR_TO_NVARCHAR** | If this option is set to Yes, all VARCHAR columns with length | + | | **MAP_VARCHAR_TO_NVARCHAR** | If this option is set to Yes, all VARCHAR columns with length |
- | | **FN_IDX_TO_IDX_VIEW** | This option defines the way how Oracle function-based indexes will be converted | + | | **FN_IDX_TO_IDX_VIEW** | This option defines the way how Oracle function-based indexes will be converted |
- | | **HINT** | This option specifies the hint or hints to be used during a bulk import of data into a table in MSSQL Database. All the possible hints are supported in our toolkit. More information about the hints supported by MSSQL BCP utility | + | | **HINT** | This option specifies the hint or hints to be used during a bulk import of data into a table in MSSQL Database. All possible hints are supported in our toolkit. More information about the hints supported by MSSQL BCP utility can be found here: [[https:// |
| **MS_QUOTED_IDENTIFIER** | This option defines the way how MSSQL native utilities (sqlcmd.exe and bcp.exe) will treat quoted delimiters and data. If this option is set to " | | **MS_QUOTED_IDENTIFIER** | This option defines the way how MSSQL native utilities (sqlcmd.exe and bcp.exe) will treat quoted delimiters and data. If this option is set to " | ||
| **PARTITION_ENABLE** | This option controls whether partition tables conversion is required. When option is set to ' | | **PARTITION_ENABLE** | This option controls whether partition tables conversion is required. When option is set to ' | ||
| **PARTITION_FILEGROUP** | The option sets filegroups names for the conversion solution for table partitioning. It can take any value which is the name of filegroup. PRIMARY filegroup is used by default. \\ Please, take into account that filegroups will not be created automatically during the migration. Please, create required filegroups manually. | | **PARTITION_FILEGROUP** | The option sets filegroups names for the conversion solution for table partitioning. It can take any value which is the name of filegroup. PRIMARY filegroup is used by default. \\ Please, take into account that filegroups will not be created automatically during the migration. Please, create required filegroups manually. | ||
| **USE_SOURCE_FILEGROUP_NAMES** | If the option is set to ' | | **USE_SOURCE_FILEGROUP_NAMES** | If the option is set to ' | ||
- | | **USE_ACTIVE_DIRECTORY** | This option switches authentication mechanism to use ACTIVE DIRECTORY authentication. Thus, if this option is set to “Yes”, option -G will be added in the commands | + | | **USE_ACTIVE_DIRECTORY** | This option switches authentication mechanism to use ACTIVE DIRECTORY authentication. Thus, if this option is set to “Yes”, option -G will be added to the commands |
| **BATCH_SIZE** | Specifies the number of rows per batch of data copied. By default, bcp copies n rows in one batch, where n is equal to the batch size. Batch size applies only when you are bulk copying in; it has no effect on bulk copying out. The smallest number bcp accepts for batchsize is 1. | | | **BATCH_SIZE** | Specifies the number of rows per batch of data copied. By default, bcp copies n rows in one batch, where n is equal to the batch size. Batch size applies only when you are bulk copying in; it has no effect on bulk copying out. The smallest number bcp accepts for batchsize is 1. | | ||
- | | **CASE_SENSITIVE_COLLATION** | This option | + | | **CASE_SENSITIVE_COLLATION** | This option |
| **TABLE_FILEGROUP** | This option defines FILGROUP for tables. | | | **TABLE_FILEGROUP** | This option defines FILGROUP for tables. | | ||
| **INDEX_FILEGROUP** | This option defines FILGROUP for indexes. | | | **INDEX_FILEGROUP** | This option defines FILGROUP for indexes. | | ||
+ | | **FK_DEL_CASCADE_SET_NULL_TO_TRIG** | This option defines how to convert ON DELETE CASCADE and ON DELETE SET NULL foreign key options from Firebird database to MSSQL. If it is set to Yes, then ON DELETE CASCADE and ON DELETE SET NULL foreign key options will be converted into a trigger that emulates the same behavior as in Firebird. \\ Possible values - " | ||
+ | | **FK_UPD_CASCADE_SET_NULL_TO_NO_ACT** | This option defines how to convert ON UPDATE CASCADE and ON UPDATE SET NULL foreign key options from Firebird database to MSSQL. If it is set to Yes, then ON UPDATE CASCADE and ON UPDATE SET NULL foreign key options will be converted into ON UPDATE NO ACTION in Microsoft SQL Server. \\ Possible values - " | ||
+ | | **USE_SCOPE_IDENTITY** | This option defines how to convert @@identity global variable when migrating from Sybase Adaptive Server Anywhere to Microsoft SQL Server. If it is set to Yes, then @@identity will be converted to SCOPE_IDENTITY() in Microsoft SQL Server. If this option is set to No, then @@identity global variable will be left as is in MS SQL. \\ Possible values - " | ||
+ | | **USE_CURSORS_IN_TRIGGERS** | If it is set to " | ||
+ | | **SEL_INTO_TMP_TAB_TO_INSERT** | This option defines the list of procedures where SELECT INTO TEMP TABLE statement will be converted into separate CREATE TEMP TABLE and INSERT INTO statements. In this options should be specified a path to a file with the names of the objects. This option works only for Informix to Microsoft SQL Server migration direction. | | ||
+ | | **SEQUENCE_TO_IDENTITY** | This option defines the conversion of a trigger that insert new generator value into a column only. If this option is set to " | ||
+ | | **EXTENT_TO_SPARSE** | This option defines the conversion of extent columns from Progress to SQL Server. When this option is set to No or Empty, will be used default conversion when each extent is converted into a separate column in SQL Server and for each Progress extent column is generated a computed column in target. If this option is set to " | ||
+ | | **CONVERT_SP_TO_SP** | The option is responsible for ensuring that objects that can be converted to functions are still converted to procedures. The value of the option specifies the path to the file in which objects names that have to be converted as procedures are specified as an XML structure, e.g. CONVERT_SP_TO_SP=C: | ||
+ | |||
+ | |||
**Example**: | **Example**: | ||
Line 45: | Line 55: | ||
CONVERT_CHAR_TO_VARCHAR=10 | CONVERT_CHAR_TO_VARCHAR=10 | ||
- | \\ | + | |
- | [[http:// | + | |
- | [[http:// | + | |
- | [[http:// | + |