A Script to insert dummy Data in all tables of DB [duplicate]

Posted on

Question :

There is an SP posted in the below link stating that it will insert dummy data in the entire DB. But the SP works only for a single table. Can anyone please share the one where we can insert dummy data throughout the db?

A Script to insert dummy Data in all tables of Database

Answer :

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

Leave a Reply

Your email address will not be published. Required fields are marked *