#Dummy data generator for sql software#

It was primarily written for populating database for development or test environments by providing values for names, addresses, email addresses, phone numbers, text, and dates. Benerator has also a plugin system that allows for instance to use it with Eclipe or Maven.ĭataFactory is an open source test data generator tool that allows you to easily generate test data. It supports many database systems (Oracle, IBM DB2, MS SQL Server, MySQL, PostgreSQL, …), XML, XML Schema, CSV, Flat Files and Excel. This test data generation tool works on Windows and Unix systems.

The products currently included in this article are: Benerator, DataFactory, Data Factory, DataGenerator, generatedata, MockNeat, MySQL Random Data Generator, pydbgen, Spawner, SQLfuzz, Synth, test-data-generatorĪdded MockNeat, MySQL Random Data Generator, pydbgenīenerator is a framework released under both open source and commercial licenses that can be used to generate high-volume test data. Do not hesitate to contact us to include any tool that that is not yet listed in this article.

This article presents some open source test data generators. Their goal is to use a predefined data structure to produce the data need for test in a specific format that could range from a spreadsheet file to SQL insert instructions. Test data generators can work in different mode: from the random approach to a more focused or intelligent way. Test data generators are tools that can help you in this task with the automatic generation of hundreds or thousands of customers, products or accounts items with different attributes for their id, email, name, etc. Sometimes you can rely on a small sample, but if you want to perform some load testing or if you want to test a feature that needs to produce a multipage invoice, then you start to need more than just two or three occurrences.

#Dummy data generator for sql software#

In most of your software testing activities, you need data.