Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

As you can see from another question of mine, generating test data is my theme right now.

At this point, I'm still generating my test data by hand. However, this process always generates small amounts of data (usually five-ten rows) since it is a manual process.

Are there any tools to automate this process? Particularly, I'd like to be able to generate 1mil+ rows.

share|improve this question
2  
Good question. +1. I hope some free options are also listed. –  StanleyJohns Aug 19 '11 at 13:07
    
related : dba.stackexchange.com/questions/449/… –  Joe Aug 19 '11 at 14:54

4 Answers 4

up vote 4 down vote accepted

You can use Visual Studio database projects with Data Generator Plans.

A nice video tutorial can be watched here: How Do I: Generate Test Data using Visual Studio Team System Database Edition?

share|improve this answer
    
I like this since it is the most easily available to me. However, to use these, I'll be forced to move from VS2005 to at least 2008. –  Richard Aug 22 '11 at 14:37
2  
You really need to download a VS2010 hands-on-lab VM and put a case together for an upgrade. The database tools (DAC packs for 2088R2, joy) are worthy on their own. The full ALM tools, if you can get dev and test on board, revolutionary. –  Mark Storey-Smith Oct 15 '11 at 20:11

Red Gate SQL Data Generator?

share|improve this answer
1  
I have used this tool and works very well! –  jrara Aug 19 '11 at 19:48
2  
Ditto. Having used both VS Data Generator and Red Gate's, Red Gate's is much better but it costs extra! ;) –  Sean Hanley Aug 24 '11 at 19:00

An excellent resource is of course the Redgate SQL Toolbelt, in particular their Data Generator

SQL Data Generator is a fast, simple tool for generating test data.

Using table and column names, field length, data types and other existing constraints SQL Data Generator immediately provides sensible generators. These can then be customized to meet specific requirements.

Ideal for both testing databases and complying with privacy legislation, SQL Data Generator provides test data fast and simply.

share|improve this answer

I'll answer this the same way I did when this was asked for mysql :

You're often better off doing this yourself, or the data may be too random, and won't have a similar distribution to what your real data will look like. (eg, indexes are good for truly random data ... not so much when there's a limited number of permutations or some values occurs more than 20% of the time)

I typically use Perl scripts to generate my simulated data, and write it out in tab delim files ... I can then either use that database's bulk importing mechanisms to load it, or I can use another script that inserts the records at a given cadence (eg, insert (x) records every (y) seconds, with a little time jitter inserted)

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.