Ispirer SQLWays Database Migration Software

[MSSQL] Subsection

This subsection is used to adjust script generations when Microsoft SQL Server is the target database, and to specify properties when it is the source database.

BIN - Specifies the directory where the Microsoft SQL Server utilities like BCP and ISQL are located.
SERVER_NAME - Specifies the server name that is used in generated scripts for the BCP and ISQL utilities (Parameter -S of BCP).
DATABASE - Specifies the database name that is used in generated scripts for the BCP and ISQL utilities.
USER - Specifies the user name that 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 that 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 SQL Server is used in generated scripts for the BCP and ISQL utilities (Parameters -T of the BCP and -E of the ISQL). When this option is set to Yes the security credentials of the network user are used and the user name (login_id) and password are not required. Possible values - 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 the 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.
USE_CONVERT_CHAR_TO_VARCHAR - Specifies what CHAR should be converted to. If set to 'yes' and the length of CHAR is equal or greater than the number specified in CONVERT_CHAR_TO_VARCHAR option CHAR datatype should be converted to VARCHAR. If set to 'no' (default) CHAR is converted to CHAR regardless the length.
CONVERT_CHAR_TO_VARCHAR - Specifies the length for CHAR to be converted to VARCHAR if USE_CONVERT_CHAR_TO_VARCHAR option is set to 'yes'.

             

Copyright © 1999-2015 Ispirer Systems Ltd. Ispirer and SQLWays are trademarks of Ispirer Systems Ltd. All other product names may be trademarks of the respective companies. All rights reserved.