Product Home
DTM Data Generator Online Documentation Prev Page Prev Page
General
Product Profile
Product Versions
Quick Start
Rule Wizard
System requirements
Connect to Database
Quick Start
Direct Connection
Connect to Desktop File
Data Sources
DSN File
OLE DB Connection
Connection Profile
Connection Information
Troubleshooting Guide
Project Properties
Program Settings
General
Interface
Rule and project
Execution
Date and Time Formats
Execution
Random BLOB Loader
Project migration
Database Model Viewer
Fill Table Rule
Table Fill Modes
Table Fill Options
Tables options
Columns options
Row count tab
Scripts
Rule Output
Preview
Fill Methods
Method Options
Random values
Values list
From table
List from file
From Values Library
Incremental
By pattern
By SQL statement
By formula
Custom generator
Named Generators
Field groups
Advanced Rules
Clear Rule
Tables Creation Options
Objects Creation
File Rule
Advanced Features
Tables Selection
Bulk project modification
Table Information
Value Library
Change target Table
Command Line
Performance Tips
Performance mode
Format Strings
Select column
Data export
How to...
Additional Info
Product Ordering
Database Utilities
Licence agreement
Demo version
Install
Uninstall
Upgrade
Support
Trademark Information
Glossary

Rule and project settings

Option Default Description
Length range of random strings 0 to 4096 If possible, the program will generate random strings with length in the defined range.
Default decimal places 0 Number of decimal places in case the program could not detect it for database column.
Special Character Set See screenshot A set of additional symbols that be used to generate random strings if allowed by related rule property.
Default rows per rule 1000 The generator will create new rules with specified rows or objects counter.
Default transaction size 500 The number of rows or objects that will be entered or created per transaction. Use 0 for autocommit.
Default NULL fill factor 10% This percentage of records from their entire number will have the Null value.
Default Data rule mode Append Default mode for data rule: append, replace, update or scramble. The generator will create new rules with this mode.
Scrambled table suffix _scrambled Target table generation method for scramble mode. The program will append specified string to name of the source table to create name for new rules.
Initial Scramble rule state Scramble all columns The user should select first case when he or she want to scramble most columns. The second choice suitable in case most columns must save original values.
Ignore timestamps On If this option is switched ON the program will generate data for "timestamp" data type depends on database system. Ignore fill method will be applied otherwise.
Create .BAK file On The tool creates a backup copy of current project before save it.
Single CPU Off for Enterprise
On for other
Enterprise version of the program does not use multiprocessor optimization when this options is switched On.

Rule and Project Settings
DTM Data Generator: Data Rule and Project settings window