SQL Data Generator
Latest version: 1.1.0
NEW:Test data generator for MS SQL Server databases
- Data generation in one click
- Realistic data based on column and table name
- Data can be customized if desired
- Eliminates hours of tedious work
- Can you spot the difference between real and non-real data?
"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
Walk-throughs
View our short screen-by-screen introductory walk-throughs
Demo video
Step-by-step demo of SQL Data Generator in action
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
"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.
