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. Importantly, settings for each table are controlled separately. One data pack 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 ofcreating SQL statements for any operation. Moreover, this data generation tool resolves foreign keys integrity and order of tables in database automatically.

Key features:

- Eleven ways to fill in the fields. Repeatable and random data generation methods.
- The product resolves master-detail relationships automatically.
- Values Library makes your test data more realistic.
- The generator creates test tables, views and procedures as well as database rows.
- Append, Replace, Update and Scramble data generation modes.
- High performance: generator inserts about 8550 test data rows per second (for 5,000,000 records project, SQL Server 2000, Pentium 1700MHz).
- Database independent. You can populate Microsoft SQL Server database as well as Oracle or PostgreSQL database. DTM Data Generator supports all common database interfaces: ODBC, OLE DB or OCI (Oracle Call Interface).