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
On the Tools menu, click Options to open the Options dialog box.
In the left-hand pane of the Options dialog box, expand the Database Tools node, expand the Data Generator node, and click Default Generators.
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
bigintcolumn, but not to a
smallintcolumn. Also, you can set only those generators that produce unique values as default generators.