SQL Data Generator

Latest version: 1.2

NEW:Test data generator for MS SQL Server databases

"In less than the time it took me to get my coffee, I had a database with 2 million rows of data for each of 10 tables. The database was filled with proper names, cities, geographical locations…"
Stephanie Beach, QA Manager, Certica Solutions

But it is not just about speed. It is also about quality data. SQL Data Generator intelligently creates realistic test data by automatically taking the table and column names into account, along with field length and any existing constraints. After all, you wouldn't want your coffee mug filled with dishwater.

Privacy legislation prohibits the sharing of live sensitive data. So if you want to demo your database to a client or develop your production database, SQL Data Generator can quickly replace the live data with realistic test data so that people will probably not even notice you've made the switch.

Whether you want to future-proof your database by populating it with large quantities of additional data and testing to see if it scales or breaks, or you simply need some starter data to highlight potential improvements to your new schema, SQL Data Generator will automate the tedious, allowing you much more time to run lots of creative tests.

Data can be pulled in from existing data sources and if you really want to show off to your boss or clients the data can be easily customized.

"Red Gate's SQL Data Generator has overnight become the principal tool we use for loading test data to run our performance and load tests."
Grant Fritchey Principal DBA, FM Global

"Red Gate's SQL Data Generator inserts 500K rows in the same time that Visual Studio Team System does 300 - not 300K, just 300."
Barry Gervin, ObjectSharp Consulting

"SQL Data Generator is simple and effective. It used to take me hours to generate useful test data, for example so we could show our web product to clients. With SQL Data Generator I generated better data in only half an hour, and then, after this initial customization was done, in only seconds with just one click."
Michael Gaertner, Quintech

Developed with you in mind

Lead SQL Data Generator developer David Connell describes how the team that developed Red-Gate's SQL Data Generator tool came to realize that database developers and DBAs already knew what they wanted for their test data. Read the SQL Data Generator blog post.