Options (Database Tools/Data Generator/Default Generators)

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

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

Concepts

Generate Test Data for Databases by Using Data Generators

Reference

Options (Database Tools/Data Generator/General)