Options (Database Tools/Data Generator/General)

Use this page to specify the options for generating data in Visual Studio Premium.

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

  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 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 Specify 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 Premium waits for a response from Microsoft SQL Server before Visual Studio Premium disconnects.

  • Preferred Method of Data Insertion (for the specified database schema provider)
    The method that you want to the data generator to use when you generate data for a database that uses that database schema provider. If you specify a value of 'SqlBulkClientSink', multiple rows are inserted simultaneously. If you specify a value of 'SqlV1CompatibilitySink', rows are inserted one at a time. For improved performance, you should use 'SqlBulkClientSink'.

See Also

Reference

Options (Database Tools/Data Generator/Default Generators)

Concepts

Generating Test Data for Databases by Using Data Generators