5 stars award

DTM Data Generator 2.03.00

Database developers and administrators know the testing routine very well. One of the most unpopular tasks is creating data sets for testing new databases. On average, it takes several hours to several days of dull work, since each data set has to be created manually (copying and pasting at best), then different parameters have to be changed one by one to make sure everything works correctly.
DTM Data Generator is a simple, powerful and fully customizable utility that generates data for database testing purposes. The great advantage of this software is that it is capable of creating a wide variety of test tables and supports user-defined templates. This data can then be easily inserted into a database. There are several ways of filling databases - randomly, by a mask, or with data from another table, file, Excel spreadsheet, Access database, etc. Importantly, settings for each table are controlled separately. One data generation project may contain multiple tables, each with own rules, value range and parameters, which makes using the tool very convenient. In addition, the program is capable of creating SQL statements for any operation. Moreover, this data generation tool resolves foreign keys integrity and order of tables in the database automatically. As an addition to the direct database population, the generator offers SQL, text, JSON and XML output.
The supplemental software (multiplatform runtime) helps users to run created project at Unix/Linux and MacOS systems.
DTM Data Generator is very straightforward and works very fast. It is a must-have tool for any database developer, QA engineer or administrator who wants to save time.

User's rating:

  • Currently 2.24/5
  • 1
  • 2
  • 3
  • 4
  • 5
Enlarge the screenshot of DTM Data Generator
[ Enlarge Image ]
Download 4.41MB DTM Data Generator

Download Direct

(4.41MB, Extension: EXE)

Download alternate to DTM Data Generator solution

Look at the free or trial alternatives and similar apps to DTM Data Generator software by the tags. It's possible also to find substitutes for the most popular titles in the Software Development category.

| Test Database Generator | Test Data Generator | Random Data Generator | Populate Database | Data For Testing |

History updates (Complete changelogs since the listing on this site)

2.03.00 [01-07-19]

Global and local variables export and import.
The schema analyzer upgrade.
Cumulative product manual update.

Other versions : 2.01.01 2.00.11 2.00.06 2.00.04 1.56.03 1.55.01 1.53.02 1.53.00 1.51.00 1.49.02 1.48.09 1.48.08 1.48.02 1.48.00 1.47.00 1.46.01 1.44.00 1.41.07 1.40.00 1.38.00 1.37.01 1.36.07 1.36.06 1.36.00 1.34.06 1.34.00 1.33.31 1.33.25 1.33.17 1.33.00 1.32.00 1.30.00 1.24.00 1.23.01 1.23.00 1.22.05 1.21.00 1.20.00 1.19.30 1.19.29 1.19.27 1.19.26 1.19.17 1.19.10 1.17.20 1.17.05 1.17.01

v2.01.01 [01-04-18]

Schema verification process improved and accelerated.
"Remove schema name" migration tool implemented.
New project migration tool: change name capitalization.
Cumulative data generation engine and value library update.

v2.00.11 [11-07-16]

Rows per rule limit extended to about 9 000 000 000 000 000 000 (Enterprise edition only).
Value Library Manager included into installation package (Enterprise edition only).
Data Masking Tool included into installation package (Enterprise edition only).

v2.00.06 [07-20-16]

Rows per rule limit extended to about 9 000 000 000 000 000 000 (Enterprise edition only).
Value Library Manager included into installation package (Enterprise edition only).
Data Masking Tool included into installation package (Enterprise edition only).

v2.00.04 [06-18-16]

Rows per rule limit extended to about 9 000 000 000 000 000 000 (Enterprise edition only).
Value Library Manager included into installation package (Enterprise edition only).
Data Masking Tool included into installation package (Enterprise edition only).

v1.56.03 [10-21-15]

Better windows shell integration.
Major pattern engine update, new functions ($WebFile, $WebFileGroup, $Case), etc.
Database Connection module cumulative upgrade.

v1.55.01 [11-20-14]

Better unique value generation for lists.
"Clear" rule performance improvement.
Better support for SQLite database connections.
New pattern engine with expressions pre-compilation.
JSON file output format added
Schema cache feature optimized for Oracle and Sybase.

v1.53.02 [03-14-14]

New GUI for "by regular expression" fill method.
User defined version control system support added for project files.
Cumulative pattern engine update: better Unicode support, new parameters and options.
Better support for export groups and custom connections to poratble format (.DGP2).

v1.53.00 [01-18-14]

New GUI for "by regular expression" fill method.
User defined version control system support added for project files.
Cumulative pattern engine update: better Unicode support, new parameters and options.
Better support for export groups and custom connections to poratble format (.DGP2).

v1.51.00 [12-06-13]

Project report extended for variables, named generators and incremental method.
New variable type: Pattern Engine statement.
Pattern engine extensions: better parameterization for $Inc, $IncDate, $IncTime and $Sequence.
HTML reports (Project and Execution) customization with CSS added.

v1.49.02 [10-15-13]

"Export one" and "Append from" operations for named generators.
Better support for Asian languages (Enterprise Unicode version).
Export to "data generation script" feature added.
Connectivity enhancements.

v1.48.09 [09-03-13]

"Export one" and "Append from" operations for named generators.
Better support for Asian languages (Enterprise Unicode version).
Export to "data generation script" feature added.
Connectivity enhancements.

v1.48.08 [06-25-13]

"Export one" and "Append from" operations for named generators.
Better support for Asian languages (Enterprise Unicode version).
Export to "data generation script" feature added.
Connectivity enhancements.

v1.48.02 [03-12-13]

"Export one" and "Append from" operations for named generators.
Better support for Asian languages (Enterprise Unicode version).
Export to "data generation script" feature added.
Connectivity enhancements.

v1.48.00 [01-16-13]

"Export one" and "Append from" operations for named generators.
Better support for Asian languages (Enterprise Unicode version).
Export to "data generation script" feature added.
Connectivity enhancements.

v1.47.00 [11-27-12]

The tool supports regular expression as a generator.
$Regexp function added to pattern engine.
Oracle Call Interface support enhancements.

v1.46.01 [11-14-12]

New $if function and logical expressions added.
Better support for nested patterns.
$List function is now support patterns.
Named generators support in the Pattern Engine.
New pattern engine functions for 'geography' and 'geometry' data.
Added export to portable project file format.

v1.44.00 [09-04-12]

Value Library update: national sample phrases for Italian, German, French and Russian languages.
Value Library additions: national first names for German and French.
Added "duplicate a few rules" feature.
Pattern engine: new $Text function options.
Pattern engine: $Variables function.

v1.41.07 [07-15-12]

New execution console options.
Better variables support in the pattern library.
Project file stores BLOB loader options.
-b command line switch.
$RInt and $RFloat pattern engine functions improvement.
Update enhancements: performance, better compound PK support.
Functions $Upper, $Lower.

v1.40.00 [05-29-12]

New execution console options.
Better variables support in the pattern library.
Project file stores BLOB loader options.
-b command line switch.
$RInt and $RFloat pattern engine functions improvement.
Update enhancements: performance, better compound PK support.
Functions $Upper, $Lower.

v1.38.00 [04-10-12]

New feature: change target table for rule.
Set of GUI updates: menu, toolbar, tooltips.
Global and Local variables.
Built-in Help system improved.
Value Library fixes and extensions.

v1.37.01 [02-09-12]

New feature: change target table for rule.
Set of GUI updates: menu, toolbar, tooltips.

v1.36.07 [12-12-11]

Custom connection support for $Table, $Query and $QueryGroup functions.
Normal and Linear distributions for $RFloat function.
'C' format for all date functions.
Performance enhancements.
Better support for custom read-only value libraries.
New "File Structure" dialog box options.

v1.36.06 [09-23-11]

Custom connection support for $Table, $Query and $QueryGroup functions.
Normal and Linear distributions for $RFloat function.
'C' format for all date functions.
Performance enhancements.
Better support for custom read-only value libraries.
New "File Structure" dialog box options.

v1.36.00 [07-18-11]

Custom connection support for $Table, $Query and $QueryGroup functions.
Normal and Linear distributions for $RFloat function.
'C' format for all date functions.
Performance enhancements.
Better support for custom read-only value libraries.
New "File Structure" dialog box options.

v1.34.06 [05-23-11]

Pattern engine new functions: $Text, $MSExcelGroup.
"Where" for $Library and $Table functions.
@'column' support in "where" clause of $Lib function.
Maximum length parameter for $Library function.
Custom column separators for $FileGroup function.

v1.34.00 [04-13-11]

Pattern engine new functions: $Text, $MSExcelGroup.
"Where" for $Library and $Table functions.
@'column' support in "where" clause of $Lib function.
Maximum length parameter for $Library function.
Custom column separators for $FileGroup function.

v1.33.31 [03-16-11]

New pattern engine replaces masks.
Special easy GUI for flat file generation.
Greater support for Oracle Instant Client.

v1.33.25 [02-02-11]

New pattern engine replaces masks.
Special easy GUI for flat file generation.
Greater support for Oracle Instant Client.

v1.33.17 [10-14-10]

New pattern engine replaces masks.
Special easy GUI for flat file generation.
Greater support for Oracle Instant Client.

v1.33.00 [02-26-10]

New pattern engine replaces masks.
Special easy GUI for flat file generation.
Greater support for Oracle Instant Client.

v1.32.00 [01-20-10]

BLOB loader was integrated in the common GUI and uses default connection.
Runtime License.
Project Migration tool was integrated into navigation tree.
New rule editor design.
New rows and entries in Value Library.
Time formats extended by milliseconds and time zones.

v1.30.00 [11-29-09]

New navigation panel.
"Schema Cache" feature optimized.
New Value Library format, library builder is no longer required.
Quick Log Viewer feature.
Named Generators feature.
Quick Report access feature for project and execution console.
New Project Report extensions.

v1.24.00 [10-22-09]

* Single transaction mode.
* Better support for modern data types: geometry, geography, hierarchy, etc.
* Enhanced support for "wide" tables (400 and more columns).

v1.23.01 [07-09-09]

New project property: default target connection for scramble mode
The version allows the user to specify custom date format for column as well as to use default one.
New schema verification procedure and changes viewer.

v1.23.00 [04-14-09]

New project property: default target connection for scramble mode
The version allows the user to specify custom date format for column as well as to use default one.
New schema verification procedure and changes viewer.

v1.22.05 [02-03-09]

Database Schema cache. New 'L' option for 'by mask' fill method. New values library lists and extensions

v1.21.00 [10-27-08]

New data generation mode: custom DLL-generator.
Curtom generator for SSNs
Minor GUI enhancements

v1.20.00 [09-16-08]

Data scramble support in the Rule Wizard.
New product settings: default rule type, scramble suffix, scramble default mode, etc.
A few project report enhancements.

v1.19.30 [08-27-08]

New tree-view project properties window
Report enhancements (project description, author, etc).
New tree-view Settings Window
New GUI and data generation options
Three quotation modes

v1.19.29 [07-31-08]

New tree-view project properties window
Report enhancements (project description, author, etc).
New tree-view Settings Window
New GUI and data generation options
Three quotation modes

v1.19.27 [05-28-08]

New tree-view project properties window
Report enhancements (project description, author, etc).
New tree-view Settings Window
New GUI and data generation options
Three quotation modes

v1.19.26 [04-18-08]

New tree-view project properties window
Report enhancements (project description, author, etc).
New tree-view Settings Window
New GUI and data generation options
Three quotation modes

v1.19.17 [03-05-08]

New tree-view project properties window
Report enhancements (project description, author, etc).
New tree-view Settings Window
New GUI and data generation options

v1.19.10 [01-31-08]

* New tree-view project properties window
* Report enhancements (project description, author, etc).
* New tree-view Settings Window
* New GUI and data generation options

v1.17.20 [10-07-07]

Better support for schema changes (add or remove columns)
Important Values Library enhancements
Minor GUI changes

v1.17.05 [08-01-07]

Better support for schema changes (add or remove columns)
Important Values Library enhancements
Minor GUI changes

v1.17.01 [12-03-06]

Better support for schema changes (add or remove columns)
Important Values Library enhancements
Minor GUI changes

Average review rating :

Useful independent reviews and opinions of the users

Review DTM Data GeneratorWrite a review « Be the first to post a review for DTM Data Generator download!

Predicted future versions and notices:

The doDownload.com constantly monitors the update of all programs, including information from the DTM Data Generator 2.03.1 changelog file, however sometimes it can happen that data are not complete or are outdated.We assume that author continue's to develop 2.4.0 version with further advanced features, and soon you will be informed. Equally important 3.0.0 upgrades of the program we will continue to monitor. Full DTM Data Generator description has been compared with the overall software database and our algorithm has found the following applications (are showed below).