Generating Data with Data Generators
You can use Visual Studio Team System Database Edition 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 example, you can specify the statistical distribution of randomly generated data, you can use regular expressions to specify the format of string data, and you can specify the percentage of NULL data generated. You can generate data that accurately models a production database without putting any production data at risk. When you generate data in this manner, you can test applications that access data without compromising production databases. The topics in this section provide guidance about how to use the data generation functionality.
Instead of generating data, you can also copy some or all the data from a source database into a target database. For more information, see Overview of Comparing Database Data.