SQL Data Generator

Latest version: 1.1.0

NEW:Test data generator for MS SQL Server databases

SQL Data Generator box shot

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.


Walk-throughs

View our short screen-by-screen introductory walk-throughs

View walk-throughs

Demo video

Step-by-step demo of SQL Data Generator in action

View this demo video

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.

Circumstances when you may want to generate test data include:

  • Future-proofing your database by populating it with large quantities of additional data and testing to see if it scales or breaks
  • Starter data is needed to highlight potential improvements to new schema

Data can be pulled in from existing data sources and can be easily customized. SQL Data Generator will automate the tedious, allowing you much more time to run creative tests.

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.