Options (Database Tools/Data Generator/Default Generators)
Use this page to specify the options for generating data in Visual Studio Premium.
To access the options page
On the Tools menu, click Options.
The Options dialog box appears.
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 Specify 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
Reference
Options (Database Tools/Data Generator/General)