Wriju's BLOG

.NET, Cloud and everything

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.


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


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