CODEWITHSUNDEEP
sql
pistacchio
pistacchio

Reputation: 58903

Simple sql table and data generator

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.

Upvotes: 3

Views: 1240

Answers (2)

Paul Creasey
Paul Creasey

Reputation: 28864

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

Upvotes: 1

Mark Byers
Mark Byers

Reputation: 838696

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.

Upvotes: 2

Related Questions