Generate Realistic Data for Database Testing Purposes
DB Data Generator is a powerful data generator that allows developers to easily populate databases with thousands of rows of meaningful and syntactically correct test data for database testing purposes.
A database that is defined, but does not contain data, is not useful for making sure your application will work as designed. You need test data. Writing your own test data generators or scripts is time consuming. DB Data Generator will help you. The tool can be used by DBAs, developers, or testers, who need sample data to test a database-driven application.
DB Data Generator makes database test data generation easy and painless. It reads your database and displays tables and columns with their data generation settings. Only a few simple entries are necessary to generate comprehensive (realistic) test data. The tool can be used to generate test data from scratch or from existing data.
The tool provides direct access to Oracle, MySQL, MS SQL Server, PostgreSQL, MS Access, InterBase and Firebird databases.
| > Download trial > Purchase DB Data Generator > Walk-through |
| "The DB Data Generator is a terrific tool. So far it has saved us a lot of time and headache creating scripts to populate test databases."
K. Gunther, Mapgistics |
DB Data Generator Key Features and Benefits
Automated Data GenerationDB Data Generator reads your database and displays tables and columns with their data generation settings. Only a few simple entries are necessary to generate comprehensive test data. DB Data Generator automatically generates appropriate data based on column charactistics such as column name, table name, data types and constraints.Generate Realistic Test DataYou can control the way data is being generated: randomly, randomly chosen from user-defined test data (such as a CSV file, a list of values, a database table), based on a sequence, randomly based on a user-defined mask, fixed value.Cross-Platform SupportDB Data Generator provides direct access to Oracle, MySQL, InterBase, Firebird, MS SQL Server, PostgreSQL and MS Access. |
Referential Integrity SupportNo manual configuration is needed for generating consistent data across multiple tables which are dependent on each other.Output to Database or to SQL ScriptOutput targets are destinations for the generated test data. Output targets can be a SQL file or a database (generated data will be inserted direct into the database).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. |
Supported Databases
DB Data Generator provides direct access to Oracle, MS SQL Server, MS Access, MySQL, InterBase, Firebird and PostgreSQL databases.> Learn More About the Supported Databases...
Editions
DB Data Generator is available in 7 editions:- DB Data Generator MultiDB Edition (support for Oracle, MS SQL Server, MS Access, MySQL, InterBase, Firebird and PostgreSQL databases).
- DB Data Generator Oracle Edition.
- DB Data Generator MS Access Edition.
- DB Data Generator MS SQL Server Edition.
- DB Data Generator MySQL Edition.
- DB Data Generator InterBase/Firebird Edition.
- DB Data Generator PostgreSQL Edition.
