Test Data Generator

Select Database | Test Data Generator menu item or just press Ctrl-Shift-D to launch Test Data Generator.

Test Data Generator is a powerful and simple automatic tool that allows you to generate test data for database testing such as performance testing, load testing and quality assurance testing. The testing data is generating according to the structure of diagram you have developed. It takes into account the data type and the size of the table fields. The method of data generation can be fully customized for each table field.

The interface consist of two tabs. The first one allows you to set general parameters for the process of test data generation. The second one allows you to tune generation parameters for each table and field.

The result of test data generator is a sequence of SQL statements which insert the data in your tables. These statements can be stored in one file or in multiple ones.

Options

This tab stand for setting the general properties of test data generation and placing the result.

File name

This field is active if option Generate only one file is checked on.

It allows set the path for storing the file with the generated SQL statements.

Directory name

This field is active if option Generate only one file is unchecked.

It allows set the path to directory for storing the files with the generated SQL statements. A separate file will be generated for each table selected for data generation.

Generate only one file

This option allows you to choose either you want to get one file containing all generated SQL statements or multiple ones: a separate file for each table.

Generate titles

Check this field if you want comments with additional information inserted before each table.

Check diagram

Starts Check Diagram tool before test data generation.

Selection

This tab allows you to tune generation parameters for each table and column participated.

The tab contains two main areas. The left one represents your diagram as a tree-like structure. It allows you to select the tables you want to generate data for, and their columns. Just tick the box near an object if you want to generate the test data for it.

Click a table or a column to tune the generation parameters for it. The Properties Pane, that is placed at the right side of the dialog, allows to set data generation parameters such as the number of records to generate, the method of data generation (random strings, random data from a user-defined list, etc) and the range of generated data values.

To get the result, click the Generate button. SQL file(s) will be generated and placed in the directory according to settings.