How to: Change the Default Generator for a Column Type

In a data generation plan, every SQL data type has a default data generator that is automatically assigned to the columns in the generation plan. You can change the default 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.

    The Options dialog box opens.

  2. In the Options dialog box, expand the Database Tools node, expand the Data Generator node, and click Default Generators.

  3. Click the database schema provider for which you want to specify a default generator.

  4. Click the row of the SQL data type for which you want to change the default generator.

  5. Click the Default Data Generator column, click the down arrow, and click a different default generator.

    If you have installed any custom generators and then restarted Visual Studio Team System Database Edition, they will appear in the list where appropriate.

    Note

    Not all generators can be used with all SQL data types. The list displays only the generators that are available for the SQL data type of the column. For example, you can assign an Integer generator 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

Concepts

Default Generators for SQL Server Data Types

Terminology Overview of Database Edition

Specify Details of Data Generation for a Column

Generate Test Data for Databases by Using Data Generators

Reference

Options (Database Tools/Data Generator/Default Generators)