Best way to generate random data into a database

Question

What is the best method to generate random data in SQL database lke name surnames tel no etc?

Is there any tool available that can do this for you?

Basically I have a database and I would like to fill it out with demo data....

Thanks!

Answer 1

If SQL Server Redgate SQL Server SQL Data Generator does this.