#Sql test data generator generator#

When this check box is selected, SQL Data Generator makes the values that are generated for the column unique. Many of the generators have a Set unique setting. SQL Type lists a generator for each SQL data type (except CLR).In addition, SQL Data Generator provides some non-specific generators for you to customize: You can change the settings for these generators as required. These generators are grouped by subject area in the Generator list. SQL Data Generator provides a number of pre-defined generators, such as FirstName, WorkingAge, Country, and so on. For example, if the column type is int, only generators that create integer values are available in the list. The Generator list only includes generators that create data of the same data type as the column. In the Column generation settings pane, you can then use the Generator list to select the generator you want to use: To select a generator for a column, in the Tables to populate list, click to view the columns for the table you want to use, and then click a column: SQL Data Generator uses generators to create the data for the tables that you choose to populate.ĭifferent generators are used to create different types of values, and to enable you to define specific parameters for the values. SQL Data Generator automatically assigns a generator to each column based on information such as table name, column name, data type, and any constraints otherwise the Regular Expressions Generator is assigned.

Sql test data generator