Data Generation

I don't normally work with a huge number of tables and do a lot of SQL work. But when I do start one of the most painful experiences is generating test data. Painful and un-rewarding. This is the data generation that is purely schema driven and does not care about the actual content of the data.

Looking around for data generation tools i stumbled upon this beauty from Red Gate software - Data Generator . I've just fooled around with the the trial version which was simple and quick. at 249 $ it strikes me as too steep for non-database specialists to splurge on personally.

Data generation tools sounds like a perfect fit for an open-source initiative with crowd sourced data for all types of industries. Anyone listening ?

Let me know if any one has free tool recommendations