通过

Generate Dummy Test Data using Data Generation Plan

  • 项目

Most of the time we struggle to get some dummy data for various types of testing. Data Generation Plan in Visual Studio 2010 helps to achieve it. It not only fills the tables based on the number of rows selected by us it also takes care of the relationship if any. One thing to remember is about the quality of data, all junk.

Let’s suppose you have a database project of Northwind. Now you need to create some 5000 categories to do a Load Testing. Very easy to achieve,

Database Project > Add New Item > Data Generation Plan. Then choose the number of Rows.

image

Once done you can choose to run by hitting F5 or use menu,

image

Your dummy data is ready, please do not try to ready it :).

Namoskar!!!

Comments

  • Anonymous
    January 11, 2011
    Hi Wirju, I've generated data successfully with independent tables but suppose i have tables with multiple relationship (Parent child relationship)means highly normilize database  kindly suggest how can i generate dummy data or pl sehre me this king article or pdf document. I'm trying to generate dummy data but i'm getting error Regards Anil Sharma anildixit83@gmail.com

  • Anonymous
    December 05, 2011
    thanks...really helped me