Sql-server – A good tool to populate database with dumthe data?

sql-server

is there a good freeware that generates fake data for SQL Server? It would be really great if the tool generate the data according to foreign key (other constraints). Its such a repetitive task I am sure there must be a good tool for this but somehow i cant seem to find it.

Best Solution

If you cannot find a free version, RedGate produce a commercial one called SQL Data Generator.