Ispirer Ispirer
 

Differences

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

Link to this comparison view

sqlways:command-line:sqlways-ini:msazuresql-section [September 24, 2018, 02:06:30 PM]
alexandr.kirpichny
sqlways:command-line:sqlways-ini:msazuresql-section [December 21, 2018, 09:25:15 AM] (current)
darya.prikhodkina
Line 5: Line 5:
 ====== Sqlways.ini File - Section [MSAZURESQL] ====== ====== Sqlways.ini File - Section [MSAZURESQL] ======
  
-This article describes sqlways.ini file [MSAZURESQL] section and options it contains. +This article describes sqlways.ini file's [MSAZURESQL] section and options it contains. 
 ^  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. |
Line 14: Line 14:
 | **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 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 Azure SQL Database 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/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. | +| **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 must be delimited with single quotation marks. When this option is set to "No", then 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. | +| **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 in 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. |+| **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. | | **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 check object names case. If this option is set to “Yes”, our 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 that 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', in that case no suffix will be added, as this option is set to “Yes”.  | +| **CASE_SENSITIVE_COLLATION** | This option checks object names case. If this option is set to “Yes”, our 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", will be used filegroup names from source database for tables and indexes.  \\ Possible values - "Yes", "No" or empty. \\ Default value - "No" or empty.  |+| **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.   | | **TABLE_FILEGROUP** | This option defines FILEGROUP for tables.   |
 | **INDEX_FILEGROUP** | This option defines FILEGROUP for indexes.   | | **INDEX_FILEGROUP** | This option defines FILEGROUP for indexes.   |
sqlways/command-line/sqlways-ini/msazuresql-section.txt · Last modified: December 21, 2018, 09:25:15 AM by darya.prikhodkina
 
© 1999-2019, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement