Top 10 Best Test Data Generation Tools in 2019

List of the best paid and open source free Test Data Generation Tools with features and comparison:

Developers and testers need a large volume of data in the database in order to test the applications.

Manually inserting data into the database is not an affordable option by price and by efforts as well.

Writing a script to insert data in the database will also be a time-consuming option. Hence, we will require some tools to insert data into the database and those tools are called Test data generation tools.

test data generation tools

Types of Test Data Generator

The 4 types of test data generation tools include:

  • Random
  • Pathwise
  • Goal
  • Intelligent

introduction to Test Data Generation Tools

Test data generation tools help the testers in Load, performance, stress testing and also in database testing. Data generated through these tools can be used in other databases as well.

Some tools also provide security to the database by replacing confidential data with a dummy one. At the same time, it also preserves the confidential data. These tools also provide an option to output the generated data in the SQL scripts. Hence in this way, these tools help a lot in testing and development of applications.

Load, performance and stress testing are just impossible without the help of these tools. These tools are easy to use and in turn, save a lot of time. It not only saves time for creating scripts, but it has also made data generation easy. With just a few simple clicks, you will be able to create a large volume of data.

A lot of tools provide complex database features like Referential integrity, Foreign Key, Unicode, and NULL values. With free or open source tools you may not get all the required features, but those companies also provide advanced features by paying some cost.

Lots of test data generation tools are available in the market. However, while selecting a tool you must consider some factors like supported databases, data generation methods, data types support, operating system support, and cost etc.

******************

=>> Contact us to suggest your listing here.

*****************

Comparison Table for Test Data Generation Tools

 PriceDatabase SupportCan generate Random Data?Unique Feature
Generate DataFreeMySQL 4 and aboveYesCustomizable Data types,
Countries plug-in
Databene BeneratorFreeOracle 10g
DB2
My SQL server
MySQL 5
PostgreSQL 8.2
HSQL
H2 1.2
Derby 10.3
Firebird
YesData Synthesization
Data Anonymization.
MockarooFreeSQL
CSV, JSON, and Excel file formats
YesCan create realistic data
Redgate SQL Data Generator$365/ userSQL Server Management StudioYesSupports Foreign Key and inter-column dependency.
IBM DB2 Test database GeneratorFree.DB2. But generated test data can be used in any database.Creates Realistic dataGenerated test data can be used in any database.
GS Data GeneratorFreeMS SQL
Oracle
DB2
MS Access
Fox Pro
Excel Files
Text Files
YesSupports system integration.
DTM Data Generator$149Microsoft SQL Server
Oracle
IBM DB2
Sybase,
Informix
MySQL
PostgreSQL etc.
YesProvides 15 methods to generate or fill in the data
EMS Data Generator$60Oracle
DB2
MySQL
SQL Server
PostgreSQL
InterBase etc.
YesGenerated data can be edited or saved through SQL script.Support for Null values.
Datanamic Data Generator MultiDB$499Oracle
SQL Server
Microsoft Azure
MySQL
PostgreSQL
MS Access
SQLite.
YesAdvance data generation and validation settings.
Upscene Advance Data GeneratorEuro 99ODBC & ADO
Interbase
Firebird
MySQL
YesYou can save the state to start and revert the testing from that state.

Top 10 Test Data Generation Tools

Enlisted below are the most popular Test Data Generation tools that are available in the market.

Let's Explore!!

#1) Generatedata.com

generatedata

It is an open source tool. It is written in PHP, Javascript, and MySQL. While installing, it will give you three options, out of which you have to select one. Those options include Single user account, single user account with login and multiple accounts.

Features:

  • Easy to use.
  • As server requirements, it needs PHP 5.3 and above and MySQL 4 and above.
  • You can customize data types as per the requirements.
  • You can also change the Export types.
  • Countries plug-in are available.

Pros:

  • It is free.
  • You can create 100 records at one time.

Cons:

  • Free account with limited data records.
  • As an open source tool, it doesn’t save your records. Hence you have to regenerate them every time.

Pricing plans: It is an open source tool and hence it is free. However, you can create only 100 records at a time. But if you pay $20, you will have an account on the website and you will be able to create 5000 records in one time. You will also be able to save these data sets.

Official URL: Generatedata

#2) Databene Benerator

databene benerator

It was first released in 2006. It supports many databases and operating systems. It can be used for performance testing.

Features

  • It supports Data synthesization and Data Anonymization.
  • It provides some open source JDBC drivers.
  • It assists almost all SQL data types.
  • It supports four operating systems, Windows, Linux, UNIX, and MAC.

Pros:

  • Operating System support.
  • Supports many databases.
  • User Manual is available here

Cons:

  • It doesn’t support SQL types like Array, Distinct, Null, and Struct.
  • Java 6 and above is mandatory.

Pricing plans: Free

Official URL: Databene benerator

#3) Mockaroo

mockaroo

Mockaroo helps you in creating random data for testing. While using Mockaroo, you can download data and upload it to your environment using SQL and CSV.

Features:

  • It supports more than 100 data types.
  • It provides support to generate data in CSV, JSON, SQL and Excel Formats.
  • It provides Mock API so that you can work with your own front end.
  • Creates realistic data.
  • For geographical fields like country, city-state etc. Mockaroo creates real and co-related data.

Pros:

  • No programming is required.
  • Easy to use.

Cons:

  • Provides limited features.
  • Very few records with the free plan.

Pricing plans:

Free: With the free plan, you can create 1000 rows.
Silver: You can create 100000 rows with this plan and the price will be $50/ year.
Gold: You can create 10M rows with this plan and the price will be $500/ year.

Official URL: Mockaroo


#4) Redgate SQL Data Generator

Redgate sql data generator

Using the Redgate SQL Data Generator, you can create data in large volumes in the SQL Server Management Studio. It generates data very quickly. You can customize column names, data types etc.

Features:

  • You can import data.
  • If there is a mismatch in data types, then it automatically converts data.
  • Supports Microsoft SQL Server 2005, 2008, 2012 R2, 2014, 2016, 2017, and on Amazon RDS.
  • It provides support for Foreign Key.
  • It also supports inter-column dependency.

Pros

  • Data consistency in multiple tables.
  • Test data can be generated within a few minutes.

Cons

  • It only supports the Windows operating system.

Pricing plans: $365/ user. It provides a free trial for 14-days.

Official URL: Redgate Sql-data-generator

#5) IBM DB2 Test database Generator

ibm db2

Using the IBM DB2 database generator, you can create test data in the DB2 database. This data can be taken in CSV, XML, and SQL format. You can create test data from the existing data or can create a completely new data.

Features:

  • Test data can be generated with the help of tools.
  • It supports Rule-based transformations.
  • It also provides other features like XML configuration and support for Referential Integrity.

Pros:

  • Test data can be generated without any manual intervention.
  • Generated test data can be used in any database.

Cons:

  • Installation is a little bit complicated.
  • As it comes as an add-on, you must have a DB2 database to use this tool.

Pricing plans: Free. It comes as an add-on with the DB2 database.

#6) GS Data Generator

gs data generator

It is an automation tool for data generation which helps testers as well as developers.

GS Data Generator provides three editions i.e. Standard, Pro, and Enterprise. Standard Edition is to help in performance and load testing of the basic projects. Pro Edition is for complex projects and supports ERP, CRM, integration etc. Enterprise edition helps software developers and consulting companies.

Features:

  • It can create test data for software marketing, integration testing, ERP etc.
  • It can also provide security to the database by replacing the important data with an artificial one.
  • At the same time, it preserves referential integrity and business logic.
  • It provides support to MS SQL, Oracle, DB2, Sybase, Access, text files, and Informix.

Pros:

  • Ease of use.
  • It helps in integration testing.
  • You can create a large data volume, at a free of cost.

Cons:

  • It supports only the Windows operating system.

Pricing plans: Free

Official URL: GS data generator

#7) DTM Data Generator

dtm data generator

This software can automatically generate data values and schema objects like tables, views etc. They also have other database tools like DTM Schema Reporter, DTM Test XML Generator etc.

Features:

  • It can create random and repeatable data.
  • Supported databases include Microsoft SQL Server, Oracle, IBM DB2, Sybase, Informix, MySQL, PostgreSQL etc.
  • Supported formats for output files are CSV, SQL Script, XML, and JSON.
  • For external data sources, it supports Excel, Access files, and XML documents.
  • DTM Data Generator provides 15 methods, to fill in the data in the database or to generate data.

Pros:

  • Supports many commonly used databases.
  • Fast data generation.
  • You will get options to replace, append and update for each table.

Cons:

  • It only supports the Windows operating system.

Pricing plans: It provides three pricing plans i.e. Standard, Professional, and Enterprise. You can buy one, three or five licenses for each plan. The prices change depending on the number of licenses.

Standard Edition: For 1 License $149.
Professional Edition: For 1 License $279.
Enterprise Edition: For 1 License $399.

You can view the detailed pricing information on their website.

Official URL: DTM Data Generator

#8) EMS Data Generator

ems data generator

EMS provides many database tools for Oracle, DB2, MySQL, SQL Server, PostgreSQL, and Interbase. It has its Headquarters in Russia and has another office in the US.

Features:

  • Generated data can be edited or saved through SQL script.
  • It provides support to databases of Oracle, DB2, MySQL, SQL Server, PostgreSQL, Interbase etc.
  • You get the facility to preview the generated data.
  • Limited support for NULL values.
  • It supports basic data types of Oracle and DB2 and supports all data types of MySQL, SQL Server, PostgreSQL, and Interbase.

Pros:

  • Free maintenance, updates and technical support for one year.
  • User-friendly tool.
  • No need to execute queries on the server to edit or save the generated data.

Cons:

  • You have to download different data generators for different databases.

Pricing plans: $ 60

Official URL: EMS Data Generator

#9) Datanamic Data Generator MultiDB

datanamic

Datanamic was launched in 1999. Datanamic data generator tool provides smart options for database testing. It has advanced data generation and validation options. It gives you the option to output the generated data directly to the database or SQL file.

Features:

  • Provides support for databases like Oracle, SQL Server, Microsoft Azure, MySQL, PostgreSQL, MS Access and SQLite.
  • It can generate completely new data and can also generate data from the existing one.
  • It has the functionality of generating data for multiple tables simultaneously.
  • Advanced data generation options that validate the data generation settings are available.
  • It provides support for referential integrity.

Pros:

  • It is helpful for database testing.
  • Provides support for cloud-based databases.
  • It is easy to use.

Cons:

  • It is an expensive tool.

Pricing plans: It provides a 14-day free trial. The prices start from $499 for a single user.

Official URL: Datanamic Data Generator

#10) Upscene Advance Data Generator

upscene

Upscene mainly develops database tools. It has its office in the Netherlands. Other tools by Upscene include Database Workbench, Hopper, FB Trace Manager, IB Log Manager, and ADS Log Manager.

The first version of Upscene Advanced Data Generator was released in 2001.

Features:

  • It can generate data from scratch.
  • It supports many data types.
  • It helps in generating the data which is related to each other in multiple tables.
  • It supports ODBC & ADO, Interbase, Firebird, and MySQL.

Pros:

  • You can save the state to start and revert the testing from that state.

Cons:

  • You have to buy separate editions for different databases.

Pricing Plans: Price for Advanced Data Generator for Interbase, Firebird, and MySQL is Euro 99 for each and for ODBC & ADO the price is Euro 199.

Official URL: Upscene Advanced Data Generator

Additional Tools

#11) E-Naxos DataGen: This tool helps in generating random data in a large volume. It will help you in testing the database applications. The latest version is 1.2 and its price starts from $479.

Official URL: E-Naxos DataGen

#12) Spawner Data Generator: It can generate test data which can be the output into the SQL insert statement. Data can be inserted directly into the MySQL 5.x database. Supported operating systems include Windows and Linux. It is available for download at a free of cost.

Official URL: Spawner Data Generator

#13) Data Factory: Data Factory by Microsoft Azure is a cloud-based hybrid data integration tool. It provides many features like ETL service, managing data pipelines, and running SQL server integration services in Azure etc. This tool works with data in the cloud and on-premise.

Azure provides enterprise-grade security to the data. Pricing starts from Indian Rupees 66.10/1000 activities per month.

Official URL: Data-Factory

#14) Data Factory by SourceForge: Data Factory by SourceForge is a Java API which can generate random data in the large volume. It is also available for download at a free of cost.

Official URL: SourceForge data-factory

Conclusion

To conclude this article on Test Data Generation Tools, we can say that Generate Data, Databene Benerator, and Mockaroo are really the best options as they can generate a large data volume at an affordable price.

By paying some additional price you will get more advanced options for data generation with Redgate SQL Data Generator and IBM DB2 Test Database Generator.

Hope you enjoyed this informative article on Test Data Generation Tools!!

******************

=>> Contact us to suggest your listing here.

*****************