A Script to insert dummy Data in all tables of DB
I needed to do this for a staging environment to test performance before release. What i ended up doing was using sql data generator by redgate. 

Way easier than a custom solution.

sql red gate sql data generator