How can I populate my database's all tables with random data?

Question

Is there such a software out there? It doesn't matter if the data itself make sense. I am just worried about the fields to get populated. Basically, it will read the table definitions and generate some data accordingly. It would also be great if it asks for how many rows to insert per table, whether the default values will be left blank or get populated, how to treat the varchars(to the full extent or up to a given,specified number of characters). Ideally free :) but commercial product suggestions are also highly welcome. Thank you all.

Answer 1

I see there is still no answer that has been chosen as the best. Besides the solutions already mentioned in this thread, I can suggest using ApexSQL Generate – a SQL data generator tool, which has the ability to quickly generate millions of rows, using various data sources, with a variety of data generators.

It features a fully functional free trial, so you can download it and test to see if it will get your job done.

Answer 2

Hey SQL Data Generator provides realistic test data you can download this from below website http://www.red-gate.com/products/sql-development/sql-data-generator/