- Home
- Test Data Management Software
- DTM Data Generator
DTM Data Generator
What it is
DTM Data Generator creates database rows and schema objects for test population, performance analysis, quality assurance, and load testing. It analyzes existing schemas and resolves master-detail key relationships, then fills fields through fifteen generation methods. The engine includes about 70 built-in functions and an expression processor. Values can come from databases, CSV or text files, Excel, XML, JSON, web resources, and user-defined scripts. Connections use ODBC, OLE DB, or Oracle Call Interface; JDBC is available through the multiplatform runtime. Supported database systems include SQL Server, Oracle, IBM DB2, Sybase, Informix, MySQL, PostgreSQL, Interbase/Firebird, and SQLite. Output can load directly into databases or become SQL scripts, text/CSV, XML, or JSON. Standard permits 128 rules per project and 10,000,000 rows per rule; Professional and Enterprise allow unlimited rules and higher limits. Pricing starts at $149, paid once, with free demo downloads.
For and against
For
- Supports Linux, macOS, and Windows
- Fifteen data-generation methods
- About 70 built-in functions
- Handles master-detail relationships
- Free demo downloads available
Against
- No free plan
- XML and JSON output require Professional or Enterprise
- Data scrambling requires Enterprise
- Standard limits rules and rows per rule
The verdict
DTM Data Generator covers schema-aware generation, many source formats, and multiple database targets for testing workflows. Its edition limits and one-time license prices make choosing the required feature tier important.
Who it suits
Standard is described for individuals and small working groups, Professional for professionals handling large databases, and Enterprise for corporate solution developers. It suits teams needing self-hosted synthetic data, masking, scheduled refresh automation, and API access.
Plans and prices
DTM Data Generator Standard — 1 license
1 license · Build 3.02
Read 3 Oct 2026 · sqledit.com
DTM Data Generator Standard — 3 licenses
3 licenses · Build 3.02
Read 3 Oct 2026 · sqledit.com
DTM Data Generator Professional — 1 license
1 license · Build 3.02
Read 3 Oct 2026 · sqledit.com
DTM Data Generator Enterprise — 1 license
1 license · Build 3.02
Read 3 Oct 2026 · sqledit.com
DTM Data Generator Standard — 5 licenses
5 licenses · Build 3.02
Read 3 Oct 2026 · sqledit.com
DTM Data Generator Professional — 3 licenses
3 licenses · Build 3.02
Read 3 Oct 2026 · sqledit.com
DTM Data Generator Professional — 5 licenses
5 licenses · Build 3.02
Read 3 Oct 2026 · sqledit.com
DTM Data Generator Enterprise — 3 licenses
3 licenses · Build 3.02
Read 3 Oct 2026 · sqledit.com
DTM Data Generator Enterprise — 5 licenses
5 licenses · Build 3.02
Read 3 Oct 2026 · sqledit.com
On the record
- Command line
- Command-line operation is available using a predefined project file, and console mode is included in Professional and Enterprise editions.sqledit.com · read 3 Oct 2026
- Database connectivity
- The product supports database access through ODBC, OLE DB, or Oracle Call Interface, with JDBC supported only by the multiplatform runtime.sqledit.com · read 3 Oct 2026
- Database systems
- Named database support includes Microsoft SQL Server, Oracle, IBM DB2, Sybase, Informix, MySQL, PostgreSQL, Interbase/Firebird, and SQLite.sqledit.com · read 3 Oct 2026
- Data generation
- The product offers fifteen methods to fill fields with random and repeatable data and an engine with about 70 built-in functions and an expression processor.sqledit.com · read 3 Oct 2026
- Data modes
- The product supports selective update, append, replace, and data scramble modes; scramble mode is an Enterprise edition feature.sqledit.com · read 3 Oct 2026
- Data sources
- Supported value sources include databases, CSV and text files, Excel, XML, JSON, web resources, and user-defined scripts.sqledit.com · read 3 Oct 2026
- Edition limits
- Standard allows up to 128 rules per project and 10,000,000 rows per rule, while Professional and Enterprise have unlimited rules and higher per-rule row limits.sqledit.com · read 3 Oct 2026
- Intended users
- The maker describes Standard as intended for individuals and small working groups, Professional for professionals and working groups handling large databases, and Enterprise for corporate solution developers.sqledit.com · read 3 Oct 2026
- Output
- Generated data can be loaded directly into a database or output as SQL scripts, text/CSV, XML, or JSON, with XML and JSON output limited to Professional and Enterprise editions.sqledit.com · read 3 Oct 2026
- Purpose
- DTM Data Generator creates data rows and schema objects for test database population, performance analysis, QA testing, and load testing.sqledit.com · read 3 Oct 2026
- Schema handling
- It analyzes existing database schemas and automatically resolves master-detail key relationships.sqledit.com · read 3 Oct 2026
- Security and privacy
- DTM soft states its free, demo, and commercial products contain no adware or spyware and do not collect or use information unless user-managed special logging is activated.sqledit.com · read 3 Oct 2026
- Support
- Enterprise includes priority technical support, and the product has built-in help and online help.sqledit.com · read 3 Oct 2026
- Trial and download
- The maker offers free demo downloads for Standard, Professional, and Enterprise editions; the download page lists Windows builds and a Java multiplatform runtime.sqledit.com · read 3 Oct 2026
