Sample test data generators
Resources
- http://www.webresourcesdepot.com/test-sample-data-generators/
- http://databene.org/databene-benerator/similar-products.html
Tools
GenerateData
GenerateData is a free, open source script written in JavaScript, PHP and MySQL that lets you quickly generate large volumes of custom data in a variety of formats for use in testing software, populating databases.
Some features:
- (JS-enabled) browser-friendly.
- Many data types available: names, phone numbers, email addresses, cities, states, provinces, counties, dates, street addresses, number ranges, alphanumeric strings, lorem ipsum text and more.
- Option to generate data in XML, Excel, HTML, CSV or SQL.
- Country specific data (state / province / county) for Canada, US, Netherlands and UK.
DBMonster
DBMonster is a tool that generates random test data and inserts it into SQL database.
CSV Data Generator
This is a Ruby based free test data generator.
Datagenerator
Datagenerator is a library and GUI for generating rule based test data for various databases like Mysql, Firebird, Interbase, MSSQL, Oracle, SQLite and PostgreSQL.
dgMaster
Data generator tool which supports many data types (primitive data types,but also names,addresses,post codes,etc.) and generates data in various formats (text,xml,db).It provides a GUI and is extensible by means of plugging-in new data-generator classes.
Spawner Data Generator
Spawner is a generator of sample/test data for databases. It can be configured to output delimited text or SQL insert statements. It can also insert directly into a MySQL 5.x database. Includes many field types, most of which are configurable.
Test Dictionary
A Java interface that quickly returns random proper names, terms and connectors. Useful for populating realistic test data.
Fresh Trash Generator
This is a Java utility package for generate random test data.
Part two
Product | Operating Systems | Supported Databases | File Formats | Special Features |
Script-based data generator, Open Source  |
Windows Linux Mac OS X BSD HP/UX Unix Solaris Other |
DB2 Derby Firebird HSQL H2 MySQL Oracle PostgreSQL SQL Server |
CSV DbUnit Excel Flat SQL Text XML Custom |
Platform-independent Abstract data model Extremely Extendible Build-Tool-Integration Load-Driver-Capabilities Domain Packages for individual industries |
GS Data Generator Data generation GUI Commercial |
Windows |
Access |
Excel |
 |
TurboData Data generation GUI Commercial License |
Windows |
Access |
CSV |
 |
tnsgen Script-based data generator Commercial License |
Windows (cygwin) |
Oracle |
CSV |
 |
DB Data Generator Data generation GUI Commercial License |
Windows |
Access Firebird Interbase MySQL Oracle PostgreSQL SQL Server |
SQL |
 |
DataGen Data generation GUI Commercial License |
Windows |
Oracle |
CSV |
 |
GT DataMaker Data Generation and Commercial License |
Windows |
DB2 |
Excel |
Database Subsetting |
DTM Data Generator Data Generation GUI Commercial License |
Windows |
DB2 |
CSV |
 |
ER/DataGen TODO Commercial License |
Unknown | Informix Oracle SQL Server Sybase |
Flat | Â |
forSQL Data Generator Database data generation GUI Commercial License |
Windows |
Access |
 |  |
Test Data Generator TDG TODO Commercial License |
Windows | Â | SQL | Â |
data maker Database data generation GUI Commercial |
 |  |  |  |
EMS Data Generator for Oracle TODO Commercial License |
 |  |  |  |
Advanced Data Generator TODO Commercial License |
 |  |  |  |
GEDIS Studio Data Generation GUI Commercial License |
 |  | CSV HTML SQL XML |
 |
generatedata.com TODO Open Source |
 |  |  |  |
dbMonster Script-based data generator Open Source |
Windows Linux Mac OS X Unix HP/UX Solaris Others |
HSQL |
x |
Ant Integration |
dgMaster TODO Open Source |
 |  |  |  |
Bogetz Data Generator TODO Open Source |
 |  |  |  |
TODO Open Source |
 |  |  |  |
Fresh Trash Generator TODO Open Source |
 |  |  |  |
DDSteps TODO Open Source |
 |  |  |  |
Datamixer TODO Open Source |
 |  |  |  |
Database Populator TODO Open Source |
 |  |  |  |
Test Data Harness TODO Open Source |
 |  |  |  |
QuickCheck for Java Open Source |
 |  |  |  |
Datagenerator Open Source |
 |  |  |  |
Test Dictionary Open Source |
 |  |  |  |
JTestDriver Open Source |
 |  |  |  |
DGAT – Data Generator Open Source |
 |  |  |  |
SQL Data Expert Open Source |
 |  |  |  |
Database Initiator Open Source |
 |  |  |  |
DDUnit – Open Source |
 |  |  |  |
DBFeeder Open Source |
 |  |  |  |
Theseus’ Thread Project Open Source |
 |  |  |  |
Data Generator Open Source |
 |  |  |  |
testgen Open Source |
 |  |  |  |
datagen Open Source |
 |  |  |  |
ToXgene Open Source |
 |  |  |  |
Clover ETL ETL Tool Open Source License, |
 |  |  |  |
Jailer Database Subsetting GUI Open Source License  |
Windows Linux Mac OS X Unix HP/UX Solaris Other |
DB2 Derby HSQL Informix MySQL Oracle PostgreSQL SQL Server Sybase |
 | Database Subsetting |