testdatatools
Tools/Redgate SQL Data Generator
Database generators

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. 1

Sources reviewed

Manufacturer / project: Redgate

When does it fit?

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

Fit still depends on your mandatory requirements.

What should you check before choosing?

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

What must your PoC prove?

Use a parent/child fixture, one invalid row and a fixed expected result. Check cleanup after failure, restore the configuration and repeat with pinned inputs. Unresolved requirements need a demonstration.

Acceptance plan, not a product test result. Execution scope and limits.

Deployment and license

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. 1 · 2 · 3

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. 1 · 2 · 3

Confirm the entitled version and operating requirements.

How you work with it

Desktop and SSMS authoring generate fixtures directly into supported SQL Server environments. 1 · 2 · 3

Export does not establish compatibility with another runtime.

Documented capabilities

Synthetic generationSQL Server schema-based fixtures
De-identification / maskingUnclear
Subsetting / subset planningUnclear
Data virtualizationUnclear
Seeded replay, scopedFixed seed · SQL Server workflow

Documentation is not a measured benchmark. Unclear is missing evidence; the comparison matrix explains the gap.

Sources and scope

Sources can cover different releases; they do not establish measured performance.

Open the cited sources (3)
  1. 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
  2. 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
  3. SQL Data Generator - Pricing

    Subscription sales model and SQL Toolbelt Essentials bundle; price table is partially dynamically rendered.

    Source checked: 2026-10-01

Use the same acceptance checks for your shortlist