Options (Database Tools/Data Generator/General)

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

Warning

These options apply only to new data generation plans. Data generation plans that you created previously are not updated if you change these options.

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 General.

Default seed
The seed value that is used in the algorithms for generating random data. The seed value appears as a property of individual columns in data generation plans. This option specifies the default that is assigned when you first create a data generation plan. You can change this property for individual columns in the Properties window to control how data is generated. For more information, see Specifying Details of Data Generation for a Column.

Default rows to insert
The number of rows of data to generate for each table in a data generation plan. This option specifies the default that is assigned when you first create a data generation plan. You can change the number of rows to insert in each data generation plan individually. For more information, see How to: Specify the Number of Rows to Generate.

Preview row count
The number of rows of data to display in the Data Generation Preview window. For more information, see How to: Preview a Data Generation Plan.

Maximum number of acceptable errors per table
The maximum number of errors that can occur while data is generated for an individual table before the operation fails for that table.

Maximum number of acceptable table failures
The maximum number of tables that can fail before the whole data generation plan fails.

SQL time-out
The time, in seconds, that Visual Studio Team Edition for Database Professionals waits for a response from Microsoft SQL Server before Team Edition for Database Professionals disconnects.

See Also