DB Data Generator is a data generation tool that generates randomized data for database load testing, quality assurance testing, usability testing and performance testing.

Key features include:

- Thirteen fill methods: Generated data can be randomly chosen from user-defined test data (such as user-defined lists, CSV files, data from another database table) or randomly generated. Randomly generated numbers and dates can be constrained to a range of values. You can also use sequences for numeric fields. For string columns you got the option to generate a random value based on a mask.

- Default field settings: When a table is added to a Data Generator project, DB Data Generator will automatically determine the best data generation settings (fill method) for the fields in the table. The field settings depend on the data type, relationship to other tables (foreign key), 'not null' setting and other table or column constraints.

- Validation of data generation settings: DB Data Generator will check your table settings and field settings before test data is generated. It will check for wrongly entered values and it will check if a field setting is valid based on the other settings.

- Metadata change detection: DB Data Generator detects changes to your database structure. Deleted objects will be deleted from the project, new columns will be added with new default field settings and changed tables or columns will be updated in your project as well. If necessary, new default field settings will be determined automatically.

Generated data can be randomly chosen from delimited text files (CSV files). You can create and use your own delimited text files or you can use the delimited text files shipped with DB Data Generator. DB Data Generator includes CSV files with data for common attributes as names, addresses, cities, countries, etc.

DB Data Generator can insert the generated data into the database directly. You can also choose to output to an SQL insert script.

A DB Data Generator project holds information like tables, column, relationships between tables and the table and field settings. Each project indicates which database to fill with data and how this data will be generated. A project can contain data generation settings for one or more tables. You can add and remove tables at any time.

Supported Databases include Firebird, InterBase, MS Access, MS SQL Server, MySQL, Oracle and PostgreSQL.