views:

363

answers:

3

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.

+1  A: 

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

adrianbanks
+1  A: 

other commercial tools. 1.EMS Data Generator for SQL Server

2.Cosort

3.Xentrix

+1  A: 

I've always written my own. It rarely takes very long to write. This way I know what I'm dealing with and if it's not correct, then I can tweak as needed and re-run it.

Dinah