Table of Contents

Search

  1. Preface
  2. Fast Clone Overview
  3. Configuring and Using the Fast Clone Server
  4. Creating Cloning Configuration Files in the Fast Clone Console
  5. Unloading Data from the Source Database
  6. Loading Data to a Target
  7. Remote Configuration Management
  8. Fast Clone Command Line Interface
  9. Troubleshooting
  10. Fast Clone Configuration File Parameters
  11. Glossary

User Guide

User Guide

Microsoft SQL Server Load Settings

Microsoft SQL Server Load Settings

On the
Runtime Settings
>
SQLServer Load Settings
view, you can configure load settings for Microsoft SQL Server targets.
The following table describes the fields in this view:
Field
Description
Parameter Name
Default
Batch size
Specifies the number of rows in a batch that is passed to the osql utility for loading data to the target. The osql utility copies each batch to the target server as one transaction.
Fast Clone uses this value as the BATCHSIZE option value in the BULK INSERT statement for the osql utility.
mssql_batchsize
10000
Max errors
Specifies the maximum number of syntax errors that can appear in the output data files before the osql utility cancels the BULK INSERT operation. The osql utility ignores all of the rows that it cannot parse and counts an error for each row.
Fast Clone uses this value as the MAXERRORS option value in the BULK INSERT statement for the osql utility.
mssql_maxerrors
10000
Column collations
The name of an SQL Server collation that Fast Clone uses to store character and Unicode data in output data files. Fast Clone uses this value to correctly specify a column collation in the format file that maps the fields in the data file to table columns. Fast Clone uses the specified collation for all of the table columns.
Fast Clone uses this value as the FORMATFILE option value in the BULK INSERT statement for the osql utility.
textfile_charset_collation
SQL_Latin1_General_Cp437_BIN

0 COMMENTS

We’d like to hear from you!