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
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 mask
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
Table Information
Value Library
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
Glossary

Product Profile

DTM Data Generator is a simple, powerful and fully customizable tool that generates data for database testing purposes.
The project is a set of generation rules. There are five principle generation rules: data rows generation (one rule correspond with one table), tables generation, objects generation, text file generation and clear rule.

  • In the first case each rule inserts (or updates) the specified number of records into one table. This case also covers data scramble feature.
  • In the second case you can create any number of tables with the same structure and with the names according to the template; you can also insert the data into the tables.
  • In the third case you can create any number of database objects (views, procedures, etc) with the same SQL text and with the names according to the template.
  • File Rule allows you to create test data without active database connection.
  • Clear Rule helps you to remove required data from your database before generator execution.

There is a picture of local menu accessed by the right click inside the rules list. See the picture below:

Using this menu you can to:

  • disable or enable the selected rule. Program skips disabled rules during project execution;
  • run one rule currently selected;
  • open editor dialog box for the current rule;
  • make a copy of the selected rule;
  • remove the selected rule;
  • move the selected rule up or down in the project.
Note: '*' in the window title means the current project is not saved. See also: Product versions.