Basic Settings

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 SQL Server 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.