DTM Data Generator is a tool that generates data for database testing. It creates test data rows, database tables and schema objects (views, triggers). The tool resolves foreign keys and order of tables automatically. SQL, text, JSON and XML output.
Version: 3.01.00Database developers and administrators know the testing routine very well. One of the most unpopular tasks is creating data sets for testing new databases.
License: Free To Try $149.00
Operating System: Windows
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 fast. It is a must-have tool for any database developer, QA engineer or administrator who wants to save time and improve the products quality.
Version 3.01.00: Table information dialog new layout and improvement: show foreign keys. Important CHECK CONSTRAINT parser and analyzer patches/ Better support cross schema master-detail references/ $Const function added to the pattern engine/ Added PostgreSQL datatypes support: 'point' ,'line','lseg','box',etc.
Version 2.03.00: Global and local variables export and import. The schema analyzer upgrade. Cumulative product manual update.
Version 2.01.01: 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.
Version 2.00.11: 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).
Version 1.56.03: Better windows shell integration. Major pattern engine update, new functions ($WebFile, $WebFileGroup, $Case), etc. Database Connection module cumulative upgrade.
Version 1.55.01: 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.
Version 1.34.06: 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.
Version 1.33.31: New pattern engine replaces masks. Special easy GUI for flat file generation. Greater support for Oracle Instant Client.