Options (Database Tools/Data Generator/Default Generators)

Use this page to specify the options for generating data in Microsoft Visual Studio Team Edition for Database Professionals.

To access the options page

1. On the Tools menu, click Options.

   The Options dialog box appears.

2. In the tree, expand the Database Tools node, expand the Data Generator node, and then click Default Generators.

• SQL Data Type
  The data type of the column in the SQL server database.

• Default Generator
  The default data generator that is assigned to columns when you create a data generation plan. The data generators that are available in this column for each SQL data type can produce values that can be converted to the type without any data loss.

  Note

  You can change the data generator that is assigned to a specific column in the data generation plan. For more information, see Specifying Details of Data Generation for a Column.

Default Data Generators

You start with the following default data generators:

SQL Data Type	Default Data Generator
bigint	BigInt
binary	Binary
bit	Bit
char	String
datetime	DateTime
decimal	Decimal
float	Float
image	Image
int	Integer
money	Money
nchar	String
ntext	String
numeric	Decimal
nvarchar	String
nvarchar(max)	String
real	Real
smalldatetime	DateTime
smallint	SmallInt
smallmoney	Money
sql_variant	Integer
sysname	String
text	String
timestamp	Binary
tinyint	TinyInt
uniqueidentifier	Guid
user-defined types	String
varbinary	Binary
varbinary(max)	Binary
varchar	String
varchar(max)	String
sql_variant	Integer
xml	String
sysname	String
numeric	Decimal

See Also

Other Resources

Options (Database Tools/Data Generator/General)
Generating Data with Data Generators