DTM Data Generator 1.22.08

DTM Data Generator 1.22.08 offers an effective tool which helps to create 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 of creating SQL statements for any operation. Moreover, this data generation tool resolves foreign keys integrity and order of tables in database automatically.

DTM Data Generator is very straightforward and works very fast. It is a must-have tool for any database developer or administrator who wants to save time.

DTM Data Generator in database system lifecycle

Why DTM Data Generator

1.  Rule Wizard helps you to create your data generation project by 2-3 clicks.
2.  Intelligent schema analyzer makes your data realistic without extra project modifications.
3.  Schema verification option prevents populating of the changed tables.
4.  Prologue and epilogue scripts support adds flexibility to your projects.
5.  The Preview window saves your time when you edit rues.
6.  Data Generation SDK helps the programmers or advanced users to add data generation features to custom scripts, applications or web solutions.

Major Features:

1. Eleven ways to fill in the fields. Repeatable and random data generation methods.
2. The product resolves master-detail relationships automatically.
3. Values Library makes your test data more realistic.
4. The generator creates test tables, views and procedures as well as database rows.
5. Append, Replace, Update and Scramble data generation modes.
6. High performance: generator inserts about 8550 test data rows per second (for 5,000,000 records project, SQL Server 2000, Pentium 1700MHz), more...
7. 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).
8. The tool supports all modern Windows versions: 9x/ME, 2000, XP, 2003 Server, Vista.

Enhancements:

• Database Schema cache
• New 'L' option for 'by mask' fill method
• New values library lists and extensions

Requirements:

• ODBC
• OLE DB
• IDAPI or Oracle Call Interface