Data SheetDB Data Generator is a powerful data generation tool that generates meaningful randomized data software database load testing, quality assurance testing, usability testing and performance testing.
Generate Useful Test DataThirteen 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 being generated. It will check for wrongly entered values and it will check if a field setting is valid based on the other settings (such as for example the number of rows to generate). It is for example possible that you've selected a fill method "Random value from data table" for a field with a unique constraint. If the number of records (lines) in the data table is not enough to generate unique values for the specified number of rows to generate, DB Data Generator will raise an error.
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.
Delimited Text Files Support. 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,....
Output of Generated Data. DB Data Generator can insert the generated data into the database directly. You can also choose to output to a SQL insert script.
Project-OrientedA DB Data Generator project holds information like tables, column, relationships between tables and the table and field settings (fill method etc). 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 DatabasesDB Data Generator can generate test data for the following databases:
- Firebird 1.5, 2
- InterBase 5, 6, 7
- MS Access 95, 97, 2000, 2003
- MS SQL Server 6.5, 7, 2000, 2005
- MySQL 3, 4, 5
- Oracle 7, 8, 9, 10
- PostgreSQL 7, 8