Generate realistic test data fast

Create large volumes of data within a couple of clicks in SQL Server Management Studio

Generating test data with SQL Data Generator

An introduction to SQL Data Generator

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

It can instantly provide generators based on table and column names, field length, data types, and other existing constraints. They can be customized to meet your requirements.

Download 14-day free trial

$385  per user

Includes Support & Upgrades

Buy now

$327  per user

Includes Support & Upgrades

Buy now

$308  per user

Includes Support & Upgrades

Buy now

For 20 or more users,
contact us for a personalized quote.

0800 169 7433


  • Create large volumes of data within a couple of clicks in SQL Server Management Studio
  • Generate meaningful test data at row level
  • Column-intelligent data generation – generate data in one column based on the data in another
  • Greater flexibility and manual control for creating foreign key data
  • Extremely fast data generation
  • Over 60 built-in generators with sensible configuration options
  • Shareable custom generators – save regexp and SQL statement generators to share with your team
  • Write your own custom generators in Python, so you can create any extra data you need
  • Seeded random data generation allows you to generate the same collection of data every time
  • Foreign key support for generating consistent data across multiple tables
  • Inter-column dependency support
  • Command-line support for automated data generation
  • Import data from existing data sources
  • Automatic data conversion when the source data is a different data type
  • Optionally disable triggers and constraints to avoid interfering with database logic
  • Support for Microsoft SQL Server 2005, 2008, 2012 R2, 2014, 2016, 2017, and SQL Server on Amazon RDS

Screenshot tour

Preview and customize the data

Generate your test data

The data has been created

Cross column generators generate data based on other columns

Use Python scripts to generate your own custom data

Generate data from within SQL Server Management Studio

SQL Data Generator case study

Case Study

“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.”
— Stephanie Beach, QA Manager, Certica Solutions

Stephanie Beach explains how the speed, simplicity and intelligence of SQL Data Generator have proved invaluable in setting up QC departments for start-up companies.

Read the case study (PDF)

Troy Hunt

Troy Hunt: Test data done right with SQL Data Generator

Software architect and Microsoft MVP Troy Hunt takes a look at creating realistic test data with SQL Data Generator.

Read the article

Compliant Database DevOps

Redgate helps IT teams balance the need to deliver software faster with the need to protect and preserve business critical data.

Your business benefits from a DevOps approach to database development, while staying compliant and minimizing risk.

Learn more about the benefits