How to: Change the Default Generator for a Column Type

In a data generation plan, every SQL data type has a default data generator type that is automatically assigned to the columns in the generation plan. You can change the default data generator that is associated with a SQL data type.

To change the default generator that is associated with a SQL data type

  1. On the Tools menu, click Options to open the Options dialog box.

  2. In the left-hand pane of the Options dialog box, expand the Database Tools node, expand the Data Generator node, and click Default Generators.

  3. In the right pane of the Options dialog box, click the row of the SQL data type for which you want to change the default generator. Click the Default Data Generator column and use the drop-down arrow to select a new default data generator. If you have installed any custom generators, they will appear in the list where appropriate. You must restart Visual Studio Team Edition for Database Professionals if it was open while you installed the generator.


    Not all data generator types can be used with all SQL data types. The list displays only the data generators available for the SQL data type of the column. For example, an Integer data generator can be assigned to an int or bigint column, but not to a tinyint or smallint column. Also, you can set only those generators that produce unique values as default generators.

See Also


Default Generators for SQL Server Data Types
Terminology Overview of Team Edition for Database Professionals

Other Resources

Options (Database Tools/Data Generator/Default Generators)
Using Standard Generators
Generating Data with Data Generators