Clever Geek Handbook

Test data generators / fastest route to create solid, non-repetitive, but not real database sample data?

I need to build a quick remote database feasibility / proof-of-concept test for a client that will be populated with typically typical company and people data (names, addresses, etc.); 150K records or so. The sample databases mentioned here were helpful:

Where can I find sample databases with common formatted data that I can use across multiple database engines?

... but, I would like to be able to generate sample data like this easily on less typical datasets. Anyone have any recommendations for out-of-the-box (or offline) solutions?

0


source to share


4 answers


For my specific need this time (which in this case was mostly "people"), I ended up with the file name Fake Name Generator 1 Million under a $ 25 CSV file alias. Seemed to be the fastest / easiest route for the amount of data I needed. It's worth checking out if your needs are similar:

http://www.fakenamegenerator.com/



http://www.fakenamegenerator.com/order.php

0


source


There is a great solution for SQL Server: RedGate SQL Data Generator . It's not cheap, but it does the job really well.



+1


source


I couldn't find a good one off the shelf, so we built it around simple concepts. If you don't find any good answers, let me know and I will go over the structure and any files you need.

0


source


See my answer to this earlier question here .

Not sure which database you are using, but hopefully it will be helpful. I still haven't used the tool myself, but I've heard better reports when I followed the link.

0


source






More articles:


All Articles