Product Home
DTM Data Generator Online Documentation
General
Product Profile
Product Versions
Quick Start
Rule Wizard
System requirements
Connect to Database
Execution
Fill Table
Table Fill Modes
Table Fill Options
Row count management
Fill Methods
Method options
Random values
Values list
From table
List from file
From Values Library
Incremental
By mask
By SQL statement
By formula
Field groups
Data Preview
Table Information
Advanced
Data Rule Properties
Project Properties
Tables Selection
Program Settings
File Structure
Values Library
Clear Rule
Project migration
Command Line
Performance Tips
Schema Viewer
Format Strings
Tables Creation Options
Select column
Objects Creation
Data export
How to...
Tools
Random BLOB Loader
Values Library Builder
Additional Info
Product Ordering
Database Utilities
Licence agreement
Demo version
Install
Uninstall
Upgrade
Support
Glossary

Product settings

The program has some settings and options aided to make your work more comfortable. There are five blocks of settings organized as tree. They are general settings (1), interface options (2), rule and project settings (3), project execution options (4) and date and time formats (5). The most important settings are:

Block Option Default Description
3 Length range of random strings 0 to 4096 If possible, the program will generate random strings with length in the defined range.
4 Maximum values from linked table 32000 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)
3 Default decimal places 0 Number of decimal places in case the program could not detect it for database column.
4 Unique value generation attempts 50 The program stops generation process when could not generate unique value of this number of attempts.
4 Repeatable mode Off The program generates same data for a few runs if this option is switched On.
2 Restore last connection On The indication that the program must reconnect to last connected database or data file.
2 Load recent project On The indication that the program must load the last opened project when it is started.
4 Save project before execution On The generator saves current project to disk file before run when this option is switched On.
4 Performance mode is default Off The generator switches to performance mode with this settings. The program should be reruned.
5 Years range 1950 to 2008 Range of the acceptable years for random dates.
3 Create .BAK file On The tool creates a backup copy of current project before save it.
1 Custom values library   Location of the custom Values Library.
3 Default NULL fill factor 10% This percentage of records from their entire number will have the Null value.
3 Default transaction size 500 The number of rows or objects that will be entered or created per transaction. Use 0 for autocommit.
3 Default rows per rule 1000 The generator will create new rules with specified rows or objects counter.
4 Verify database schema On The indication that the program must verify database schema before project execution.
3 Special Character Set See screenshot A set of additional symbols that be used to generate random strings if allowed by related rule property.
4 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)
4 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.
1 Log level Default Product log level: core (default level), full log or disable logging.
3 Single CPU Off for Enterprise
On for other
Enterprise version of the program does not use multiprocessor optimization when this options is switched On.

Settings Tree
settings tree

General Settings

Interface Options

Rule and Project Settings

Project Execution Options

Date and Time Formats