Data Generation Plans

You can use Microsoft Visual Studio Team Edition for Database Professionals to generate meaningful data for testing. You can generate random data, generate data from existing data sources, and control many aspects of data generation. For more information, see Overview of Generating Data.

To generate data, you must create and run a data generation plan that contains the information about which tables and columns you want to fill. Your plan also contains details about the amount and kind of data that you want to put in each column. You can save your plan as a file in the database project so that you can edit and reuse the plan to generate data.

The topics in this section explain the steps to create and run a data generation plan.

In This Section

• How to: Create Data Generation Plans
  Lists the steps to create a data generation plan.

• How to: Specify Tables for Data Generation
  Discusses the restrictions and requirements for what tables you can and cannot include in a data generation plan. Also lists the steps to specify tables in a data generation plan.

• How to: Specify the Number of Rows to Generate
  Lists the steps to specify how much data will be generated for each table.

• How to: Specify Columns for Data Generation
  Lists the steps to specify columns in a data generation plan.

• Specifying Details of Data Generation for a Column
  Describes how to configure data generation for a column. Describes how to set the generator for each column and how to set the data generator properties.

• How to: Preview a Data Generation Plan
  Lists the steps to preview a data generation plan. This topic helps you customize the data that is generated in each column.

• How to: Run a Data Generation Plan to Generate Data
  Lists the steps to run a data generation plan and generate data.

• Walkthrough: Creating and Running a Data Generation Plan
  Walks you through the steps to create and run a data generation plan to fill tables with random data.

Reference

Microsoft.VisualStudio.TeamSystem.Data.DataGenerator

Related Sections

• Using Standard Generators
  Contains links to topics that describe how to use the standard data generators, such as the integer, string, and regular expression generators.

• Creating Custom Generators
  Contains links to topics that describe how to use extensibility to create, register, and deploy custom data generators.