DTM Data Generator 1.22.05

DTM Data Generator 1.22.05 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.

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 very straightforward and works very fast. It is a must-have tool for any database developer or administrator who wants to save time.

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.
   

How can a data generator help you?

1. Database Developers. Modern information systems work with extra large data. Even if you create a great database application, you cannot be sure that it will work in real circumstances. A database developer should populate the test database with millions of realistic data records and run the application again and again. It is the only way to ensure that your users will get an application with the necessary performance and response time. DTM Data Generator helps you to populate a database. During tests, a new user of the product could install and configure the data generator, create a project file and fill a database (30 tables with relationships) only within about 30 minutes.
2. QA staff and testers. It is a bad idea to test an application with an empty database. A database with only limited types of various data is no good as well. DTM Data Generator helps you to populate the database with complete and realistic data.
3. IT managers. It is very important to protect corporate data and privacy when you work with an outsourcing company. DTM Data Generator offers the data scramble feature that allows you to share data without the risk of disclosure.
4. Database Administrators. Providing acceptable performance is one of the administrator's most important tasks. The administrator should have a test database with realistic data to make the necessary changes in the database settings and options. Also, a realistic database helps you to find out how many times you have to complete general tasks like backing up data and rebuilding the index without any risk for production data.
5. Performance analysts, Query optimizers. The process of tuning the performance requires various data sets. With DTM Data Generator, you can create databases with the necessary properties like nullability, density or the number of rows.

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.

Requirements:

• ODBC, OLE DB, IDAPI
• Oracle Call Interface