Test (Sample) Data Generators

22°

Sample / test data is an effective way to test web projects & applications. Other than meaningless data, real names, addresses, zip codes can make the whole testing stage easier.

WebResourcesDepot have collected some nice free test data generators which you may find useful:

 

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.

Generate Sample Data

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.

Test Data Generator

 

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.

Data Generator

 

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.

15 Comments
  1. Reply noertz February 9, 2008 at 12:16 PM

    Good project , thanks.

  2. Reply Forrest March 3, 2008 at 12:28 AM

    Interesting set of resources … looks like you’ve got just about every angle covered. Realistic looking test data ( beyond lorem ipsum ) is important for real-world applications.

  3. Reply Abx78 June 4, 2008 at 7:06 AM

    What about the sogame FF extension?

    http://sogame.awardspace.com/dummylipsum/

  4. Reply Ozn September 5, 2008 at 12:13 AM

    Thanks…….

  5. Reply Renato Garcia March 9, 2009 at 6:23 PM

    Take a look at http://databene.org/ also.

  6. Reply Tristan Denmat July 17, 2009 at 5:29 AM

    Hi all,

    you should take a look at the free community edition of Gedis (www.genielog.fr). This tool really helps you to produce sophisticated and realistic data for your tests.

  7. Reply jorgenorid February 19, 2010 at 4:08 PM

    Thaks a lot

  8. Reply R3D June 13, 2010 at 6:05 AM

    Nice one, thank you.

  9. Reply mcanti June 15, 2010 at 12:28 AM

    For generating persons/identities: http://www.fakenamegenerator.com/gen-random-gr-gr.php for different countries

  10. Reply Farouk July 15, 2010 at 5:41 AM

    thanks alot

  11. Reply Martin August 15, 2011 at 2:47 AM

    Here is something for generating latitude/longitude values: http://www.routegen.com

  12. Reply Tremayne Christ February 28, 2012 at 12:27 PM

    I wrote a test data generator project for Data Synchronisation Studio. It can generate a large dataset consisting of 100s of millions of rows of realistic testing data. Here is a blog post all about it. http://www.simego.com/Blog/2012/02/Test-Data-Generator-Download-for-Data-Sync

  13. Reply Florian April 28, 2012 at 7:34 PM

    We are working on making our tool better!
    http://www.test-data-generator.com
    Help us with feedback and support the test data generator team. Currently with over 2,000 different first names, 15 data types and over 10,000 fake company names.

    Cheers,
    Florian

  14. Reply Rich Alberth May 7, 2012 at 8:04 PM

    Take a look at DataRoller – a new project just released at dataroller.sourceforge.net.

    From the user manual: “DataRoller is a Java application that will insert piles of good looking data into your favorite databases so you can move in and be happy.”

    DataRoller inserts rows into a database based on a file describing your tables and columns.

    Sample DataRoller file to populate an invoices table:

    table invoices
       insert 4 rows
    {
       invoice_id    sequence(),
       alt_key_uid   guid(),
       name          lorem(20..80),
       label         pattern(“UU-NNNN”),
       status        choice(“UNK”,”SHP”,”CLS”, “OPN”,”INP”)
    }

  15. Reply KFR JAnssens February 8, 2013 at 10:26 AM

    Since some time I am working on a test data generation tool aimed at testers and QA people, not aiming at technical DBA’s and developers.

    The advantage over other tools is that it uses the javascript engine from the browser to generate lots of data, so you don’t need to install any software.

    Please take some time to review my application and list it if you find it ok.

    Any comments or suggestions are welcome.

    http://tedagen.com – TEst DAta GENerator

Leave a reply

Search