The dialog box for each type of the data generators contains basic settings and custom settings. You can customize the data generators by changing the basic and custom settings.
The basic settings common to all the data generators are:
Generator
Displays information on a selected data generator. dbForge Data Generator for MySQL automatically selects a generator for each column based on column data type and related constraints. You can select a desired type of generator from the list of available data generators. Different generators create different types of data for the table to be populated.
Set values to be unique
Select to make the values generated for a column unique. If the column schema has a uniqueness constraint (such as a unique index or primary key), the check box is selected by default.
Include NULL values
Selected by default. Includes NULL values into random fields of a column to be populated. In the percent box, type or select the percentage of NULL values to be included into the column.
Include empty values
Includes empty values into random fields of a column to be populated. In the percent box, type or select the percentage of empty values to be included into the column.
Value distribution mode
This group of settings defines how the generated values are distributed in the column.
Random by timestamp
Selected by default. Generates values randomized by a timestamp.
Random by seed
Generates values in a random order using a specified seed value.
Sequential
Generates values from a list in a sequential order.
Loop data
Selected by default. Available in all modes. Select to cyclically read data from a file.
Repeat each value
Select to repeat values and specify the number of repetitions.
Notes Text Box
Type your notes on generator in this box.
The custom settings are separately described for each data generator in the corresponding topics.