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. 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 database automatically. As addition to direct database population the generator offers SQL, text and XML output.
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.
Better windows shell integration.
Major pattern engine update, new functions ($WebFile, $WebFileGroup, $Case), etc.
Database Connection module cumulative upgrade.
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.
Custom connection support for $Table, $Query and $QueryGroup functions.
Normal and Linear distributions for $RFloat function.
'C' format for all date functions.
Better support for custom read-only value libraries.
New "File Structure" dialog box options.
New pattern engine replaces masks.
Special easy GUI for flat file generation.
Greater support for Oracle Instant Client.