Simple sql table and data generator

Question

Hi to all!

I didn't know where to look or ask, so I thought that SO could be a good place to start. My girlfriend, who's studying economics, has a "informative systems" exams. Part of the exam is about the sql language. It's pretty basic stuff, only selects. She has a plethora of written test cases out of her textbook.

I'm helping her with the exercises, but I'd love to have a simple program (linux or mac or, even better, web-based) where to input table structures with relations (foreign keys), have it generate a sample data set and being able to query it with the standard sql language.

I've thought about making it myself, but her exam is in a short time and I'd rather spend this time helping her.

Thanks in andvance

EDIT:

Thanks to the first answers, but, as in the body of my answer, I don't have a Windows machine, so I'm lookng for a linux or mac or web solution. Thanks again

Answer 1

If you are using SQL Server you could try Red Gate's SQL Data Generator. It's not a free product, but there's a 14 day trial, which I guess is enough for you.

Answer 2

perhaps ms sql server express and a trial edition of RedGate SQL Data Generator