How to populate database with generated data in visual studio 2010 / SSMS 2008?

Question

In my (c#) Visual Studio 2010 project i have a reference to a database.

However, the database is empty. I would like to insert some bogus data in this database so that i can test my app.

Are there any tools / methods for doing so?

Thanks!

so i from http://msdn.microsoft.com/en-us/library/aa833237(v=vs.100).aspx that it is not possible? — jorrebor, Oct 25 '12 at 10:53

score 1 · Accepted Answer · answered Oct 25 '12 at 10:53

1

If you're using sql I would recommend redgate's sql data generator it isn't free but does a very good job of creating useful test data

answered Oct 25 '12 at 10:53

wisey

if you only need to do it once, then you can take advantage of their 30 day frree trial. – paul Oct 25 '12 at 10:55
great, does indeed exactly what i want. i'll opt for a lincense with the management. – jorrebor Oct 25 '12 at 11:30

score 0 · Answer 2 · answered Oct 25 '12 at 11:02

If you have created or create a database project in VS2010 there are tools built in to generate data:

It says you need Visual Studio Premium but I am using VS2010 Profesional and I can do it.

2 Answers2