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.
Recent Changes: 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).
Install Support: Install and Uninstall
Supported Languages: English
Additional Requirements: ODBC, OLE DB, IDAPI or Oracle Call Interface