About Ispirer Systems

Ispirer Home Page Database Migration Application Conversion Downloads


Sqlways.ini File - Section [MSAZURESQL]

This article describes sqlways.ini file's [MSAZURESQL] section and the options it contains.

Option name Description
BIN Specifies the directory where Microsoft SQL Server utilities like BCP and ISQL are located.
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.
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 TRUSTED_CONNECTION (see below) must be set to “No”.
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 TRUSTED_CONNECTION (see below) must be set to “No”.
TRUSTED_CONNECTION Specifies that a trusted connection to Microsoft Azure SQL Database is used in generated scripts for the BCP and ISQL utilities (Parameters -T of BCP and -E of ISQL). When “Yes” is specified, 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”.
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 this option:
* ACP - ANSI/Microsoft Windows (ISO 1252).
* OEM - Default code page used by the client. This is the default code page used by bcp if -C is not specified.
* RAW - No conversion from one code page to another is taking place.
* <value> - Specific code page number, for example, 437.
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 “Yes” identifiers should be delimited with double quotes and literals should be delimited with single quotation marks. When this option is set to “No”, only brackets [] can be used to delimit identifiers and double quotation marks will be used to delimit character strings.
Possible values - “Yes”, “No” or empty.
Default value - “No” or empty.
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 into the commands to SQLCMD and BCP utilities. The -G switch requires at least sqlcmd version 13.1.
Possible values - “Yes”, “No” or empty.
Default value - “No” or empty.
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 checks object names case. If this option is set to “Yes”, the tool will check the object names taking into account name case. If two objects have the same names and they are written in the same way, for example 'Tab' and 'Tab', in this case suffix will be added to one of the objects. If there are two objects with the same names, but they are written in different manner, for example 'Tab' and 'TAB', no suffix will be added, as this option is set to “Yes”.
USE_SOURCE_FILEGROUP_NAMES If this option is set to “Yes”, filegroup names from source database will be used for tables and indexes.
Possible values - “Yes”, “No” or empty.
Default value - “No” or empty.
TABLE_FILEGROUP This option defines FILEGROUP for tables.
INDEX_FILEGROUP This option defines FILEGROUP 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 - “Yes”, “No” or Empty.
Default value - “No” or Empty.
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 - “Yes”, “No” or Empty.
Default value - “No” or Empty.
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 - “Yes”, “No” or Empty.
Default value - “No” or Empty.

Example:

[MSAZURESQL]
MAX_ERRORS=10
CASE_SENSITIVE_COLLATION=No