| Option
|
Default
|
Description
|
| Maximum values from linked table |
128000 |
The program will not use more than defined number of values in
From Table fill method. If you set the
value to 0, all values will be selected (note: it may lead to the
large consumption of RAM) |
| Maximum LOB size |
4095 |
The program will not generate large objects longer this
value. |
| Unique value generation attempts |
50 |
The program stops generation process when could not generate
unique value of this number of attempts. |
| Repeatable mode |
Off |
The program generates same data for a few runs if this option
is switched On and "initial value" is same. |
| Repeatable mode initial value |
12345 |
The value that the program will use as base for repeatable
mode. |
| Remove Comma Separator from numbers |
On |
This option is useful for external data sources that contains
numeric values with separators like 1,020.50 (the program will
import 1020.50 is this options is switched on) |
| Recreate table for scrambling |
|
The program will drop and create target table between each
scrambling execution. Use existing one otherwise. |
| Custom quote chars |
On |
The program will use this symbol (or symbols) to quote names.
By default it will use system symbols
(SQL_IDENTIFIER_QUOTE_CHAR). |
| Use 'N' Unicode prefix |
On |
The generator will add N before Unicode strings when this mode
is switched On. Example N'abc' instead of 'abc' |
| Verify database schema |
On |
The indication that the program must verify database schema
before project execution. |
| Save project before execution |
On |
The generator saves current project to disk file before run
when this option is switched On. |
| Single Transaction Mode |
Off |
The generator will execute whole project as single transaction.
In any rule or statement fails project will be rolled back. |
| Performance mode is default |
Off |
The generator switches to performance
mode with this settings. The program should be reruned. |
| Bulk Insert Mode |
Off |
Very fats mode to load data to local MS SQL Server. IMPORTANT:
it is not compatible with another output modes. You should not use
this mode together with "Save generated data to Text File" project
option. |
