SQL Data Generator

SQL Data Generator is very simple and easy to use. If you don't want to customize the data, simply select your database and click 'Generate Now', and it will be populated with realistic test data.

You may want to 'future proof' your database by populating it with large volumes of data and running tests. Or you may have no data at all. It is not good practice to test on live sensitive data – for example credit card numbers and social security details. Using test rather than live data also aids compliance with data protection legislation.

Easy – it saves you hours (if not days) manually entering the data yourself.

Yes! SQL Data Generator automatically assigns an appropriate generator based on column name, for example realistic looking addresses.

You can tweak the settings on the generators provided, for example change the range of numeric values or generate strings from regular expressions.

You can easily add to the list of available generators by adding .xml files to the config folder.

There is a weighted list generator that allows you to assign a percentage to a data type.

Assigning column data a seed value easily allows you to use the same data in one project to the next.

'Edit project' allows you to add scripts to be run pre- and post-generation in the order that they are entered.

In the 'Table Generation Settings' pane, select use existing data source, source type CSV file.