Test Data Profiles

A test data profile is a named class of data types used to generate test data to one or more table columns. You can create test data profiles that contain number, character, or date/time data.

For example, you could create a test data profile called Address, that uses the character class, and then associate that profile with the columns Employee Location, Store Location, and Client Address.

You can apply a test data profile to a domain and thus generate the test data to all columns that use that domain. You can also assign default test data profiles for each of the number, character, and date/time classes, and have these default profiles automatically applied to any column that does not have a profile specifically associated with it.

Note:

The following objects are not taken into account when you generate test data:

Alternate keys
Foreign keys
Business and validation rules
Binary, sequential, OLE, text or image data types
Trigger contents

Creating a Test Data Profile
You can create a test data profile in any of the following ways:
Test Data Profile Properties
You can modify an object's properties from its property sheet. To open a test data profile property sheet, double-click its Browser entry in the Test Data Profiles folder.
Assigning Test Data Profiles to Columns
To generate test data for a column, you must associate a test data profile to it.

Parent topic: Generating Test Data to a Database