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.
What's New in this Release: 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).
Link to DTM Data Generator sample code
Platform: WinXP,WinVista,Win7 x32,Win2000,Windows2000,Windows2003,WinServer,Windows Vista
Business::Databases & Tools
Date Added: Oct 30, 2006
Last check for an update: May 24, 2017
Last version date: Nov 06, 2016
Page Visit: 157
Malware Status: Clean
Scan Date: Apr 03, 2008