Redgate SQL Data Generator

Redgate SQL Data Generator creates schema-aware synthetic rows for SQL Server and supported hosted deployments, with foreign-key consistency, custom generators, command-line automation, and fixed-seed repeatability.

Sources reviewed

When should you consider it?

Best for SQL Server teams needing fast, schema-aware synthetic data, foreign-key consistency, custom generators, command-line automation, and repeatable seeded runs.

Editorial fit assessment based on the sources below.

What are the limits?

SQL Server scope; current requirements list Windows 10/11 and SSMS. Privacy masking, database subsetting, and virtualization are not documented.

Which capabilities are documented?

Synthetic generationDocumented · source

De-identification / maskingNot verified

Subsetting / subset planningNot verified

Data virtualizationNot verified

Seeded replay, scopedFixed seed · SQL Server workflow

Documented means a cited vendor source describes this scoped capability. Not verified means the reviewed evidence cannot establish it. Neither is a hands-on test result.

How is it deployed and licensed?

Installable Windows desktop/SSMS tool; generate directly against SQL Server environments including Azure SQL Database, SQL Server on AWS RDS, and Google Cloud SQL for SQL Server. Command-line automation is documented; no cloud-hosted generator service is described.

Commercial annual per-user subscription; a 14-day trial and SQL Toolbelt Essentials packaging are documented. Public pricing varies with license quantity; use the linked vendor page for current terms.

Sources and scope

SQL Data Generator: Generate realistic test data fast
Product purpose, SQL Server focus, foreign-key and inter-column consistency, custom/Python generators, explicit seeded repeatability, CLI, 14-day trial, listed subscription price.
Source checked: 2026-10-01
Requirements - SQL Data Generator 4
Windows 10/11 and supported SQL Server versions/deployments, including Azure SQL Database, Amazon RDS, and Google Cloud SQL.
Source checked: 2026-10-01
SQL Data Generator - Pricing
Subscription sales model and SQL Toolbelt Essentials bundle; price table is partially dynamically rendered.
Source checked: 2026-10-01

What should you verify in a proof of concept?

Your database version, schema constraints and target formats.
The exact product, edition, deployment and license entitlements.
Your business assertions and the meaning of repeatability for your output.
A failed run, cleanup and a repeat run on controlled inputs.