Ispirer SQLWays Database Migration Software

Microsoft SQL Server Advanced Options

This dialog box specifies advanced options for the Microsoft SQL Server target database. The following options are available:

In the BIN directory box, enter the path to the folder where the Microsoft SQL Server utilities like BCP and ISQL are located. You can click (...) to indicate this folder .
In the Max errors box, enter 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). Default number is 10.
In the Codepage box, select the code page of the data in the data file for the BCP utility (Parameter -C of BCP). The following code pages are:
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.

To specify Microsoft SQL Server options in the command line

SQLWays command line - [Microsoft SQL Server] subsection

             

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.