Generate realistic test data fast
Create large volumes of data within a couple of clicks in SQL Server Management Studio
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$365 per user
Download free trialPart of the SQL Toolbelt
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
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.
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“SQL Data Generator is almost magical when you see it in action over your own data schema”
“Redgate's SQL Data Generator inserts 500K rows in the same time that Visual Studio Team System does 300 - not 300K, just 300.”
“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 customisation was done, in only seconds, with just one click.”
“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, FK links and I was able to use the Regex Generator to finely tune specific columns data.”
“A fantastic tool that is very much needed by SQL Server DBAs and developers.”
Part of our Database DevOps solution
Redgate’s Database DevOps solution lets you extend your DevOps practices to SQL Server databases so that you can optimize productivity, agility, and performance across the full database lifecycle and become a truly high performing IT organization.
From safely making a change in development through to monitoring its impact in production, Redgate is with you every step of the way. We give you the tools and insight you need to optimize your development processes, so you can keep your team moving, keep adding value, and keep your data safe.
Learn more about the benefits