SQL Data Generator

Generate realistic test data fast

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

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

1 Year Subscription

/user

Equivalent to /user/mo

Buy now

Part of SQL Toolbelt Essentials

Features

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 is almost magical when you see it in action over your own data schema”
Troy Hunt, Software Architect

“Redgate'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

“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 names, cities, geographical locations, FK links and I was able to use the Regex Generator to finely tune specific columns data.”
Stephanie Beach, QA Manager, Certica Solutions

"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)

Automated data syncing with SQL Data Compare Pro and TeamCity

Software architect and Microsoft MVP Troy Hunt uses SQL Data Compare Pro to sync data back down from production, to his test and development environments.

Read the article