DBPro - Data Generator Options
[NOTE: Please log into Team System Rocks to see the images]
One of the nice features in Team Edition for Database Professionals (DBPro) is the ability for DBPro to generate test data for your database schema. DBPro will take your schema, and based off of it, generate valid data for you to use in your tests. When you create a new data generation plan, you will notice two things. First, it defaults the number of rows generated for each table to 50. Second, that for each column, depending on the column type, it automatically selects a data generator to generate the data for that column. For example, for a column of type VarChar, it will use a data generator of String, to generate a string value for that column.
These options are customizable. To do this, open Visual Studio, and from the main menu, select Tools->Options. In the tree on the left-hand side, select Database Tools->Data Generator. Under Data Generator, select General.
These are some of the general options for data generation. You can select the default seed that will be used for generating the random data. You can also select the default number of rows generated by the data generation plan, along with several other options.
If you select Default Generators, you can adjust which default generators are used with which SQL column types:
