Ispirer Website Ispirer Toolkit Overview Free Trial

Microsoft SQL Server: Advanced Options

At the “Target Options” page of SQLWays Wizard you can see the button “Advanced”, which opens the window with additional options for target database:


FILEGROUPS Section

Tables

This option defines FILGROUP for tables.

Indexes

This option defines FILGROUP for indexes.

Use Separate Filegroups

Use Filegroup Names From Source Database If checked, filegroup names from source database will be used for tables and indexes.

Common Options

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.

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.

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 can be found here: MSSQL Server BCP Hints.
Possible values: Hints supported by MSSQL Server.

Codepage

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:

  • ACM - ANSI/Microsoft Windows
  • 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.
  • 650001 (UTF-8) - A format in the Unicode coding system that uses from one to four bytes.
  • UTF-16 - A two-byte format in the Unicode coding system.
  • <value> - Specific code page number, for example, 437.

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”, only brackets [] can be used to delimit identifiers and double quotation marks will be used to delimit character strings.

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 written in the same way, for example 'Tab' and 'Tab', 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 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.


If you have any questions, please contact us: support@ispirer.com