Fast Clone
- Fast Clone 11.0
- All Products
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
|