Test Data Generator

You can't test your queries on an empty database and this is where the Test Data Generator tool comes into play.

Generate thousands of rows of data quickly, for query performance profiling, application demos and other testing purposes like report printing.

  • Generate real looking data
  • Automatically determine table order
  • Support for binary files

Data Generator Projects

To generate data you can select the tables that you want data for and enter the number of rows.

Each individual column has different options available, depending on the data type. For example, a VARCHAR column can be filled with e-mail addresses, while an INTEGER column can only contain numbers. There's options available for:

  • Fixed values
  • Sequential values
  • Random values
  • Values from a list
  • Values from a folder
  • Real life-like data for street addresses, names and e-mail addresses

Results

As you can see, the results are life like data that can be indexed and used in sample reporting or demo purposes.