How to: Specify Defaults and Options for Data Generators
You can specify default values and options that control how you generate test data in Visual Studio Premium. For example, you might want to change the default seed for data generators, or the default number of rows generated for each table in a data generation plan. You can also control error handling when you generate data if you change the values of options such as Maximum number of acceptable errors per table and Maximum number of acceptable table failures. Finally, you can specify how data is added to tables when you run a data generation plan.
To specify defaults and options for data generators
On the Tools menu, click Options.
In the Options dialog box, expand the Database Tools node in the list of option categories, and then click the Data Generator node.
Update the values that you want to change.
For more information about individual options, see Options (Database Tools/Data Generator/General).
If you want to change how data is inserted into tables, find the table row for the database schema provider whose insertion method you want to change. In Preferred Method of Data Insertion, click SqlBulkClientSink to use the faster bulk insertion method of inserting rows, or click SqlV1CompatibilitySink to use individual INSERT statements.
Click OK to save your changes, or click Cancel to abandon your changes.
See Also
Tasks
How to: Change the Default Generator for a Column Type