17. Data generator

Data Generator tool is intended for quick and convenient filling of table fields with a large amount of data.

Fig. 17.1 Data generator

Select a table. Fields and their types will be displayed. Choose checkbox for the field if you want to generate data for it. Otherwise this field will be filled with NULL values.

Specify number of records to be generated. Generating large amounts of data may take some time.

In Commit after field, enter the number of rows after insertion that will commit.

Errors may occur during generation. By default, they are not written to log file. Tick the corresponding checkbox so that all errors are recorded in the log.

If errors occur during the generation process for some records (e.g. due to column constraints), the generator continues by default. This behaviour can be changed by ticking the Stop on error checkbox.

Method of generation can be selected for each field of the table:

• Random - Depending on the field type, different generation parameters are configured.

• Get from another table - In this method you need to select a table, column and number of records. The records from the table are selected randomly in the specified number, then the main table is filled from this list of values.

• Get from list - The values of the list form the content of the field. The list must consist of elements of the corresponding data type. The delimiter can be any single character or escape-sequence starting with a backslash (\). The list itself can be entered manually in the field provided for this purpose, or loaded from a file.

• Autoincrement - For auto increment the initial value, step and direction of step movement (up or down) are configured.