testdatatools
Tools/ApexSQL Generate by Quest
Database generators

ApexSQL Generate by Quest

ApexSQL Generate creates SQL Server test data using random, regex, and incremental column generators. Quest presents it in SQL DevOps; latest located release notes are version 2022.02.x. 1

Product status changed

Manufacturer / project: Quest

When does it fit?

Best for SQL Server development teams already using Quest/ApexSQL tooling that want configurable synthetic rows, FK-aware relationships, and exportable test data. 1

Fit still depends on your mandatory requirements.

What should you check before choosing?

SQL Server scope; Quest lists it in the SQL DevOps toolkit. Current official evidence for seeded output, privacy masking, subsetting, or virtualization was not found. 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

Windows desktop application with SQL Server Management Studio integration; supports direct SQL Server, Azure SQL Database, and Amazon RDS for SQL Server per the 2022.02 requirements. Quest bundles Generation in its SQL DevOps toolkit; exact standalone availability is unclear. 1 · 2 · 3

Quest offers the ApexSQL DevOps toolkit commercially, with trial and purchase/request-pricing paths. Confirm the current Generate entitlement and price with Quest. 1 · 2 · 3

Confirm the entitled version and operating requirements.

How you work with it

Windows desktop and SSMS integration generate data for the documented SQL Server targets. 1 · 2 · 3

Export does not establish compatibility with another runtime.

Documented capabilities

Synthetic generationSQL Server generators · 2022.02
De-identification / maskingUnclear
Subsetting / subset planningUnclear
Data virtualizationUnclear
Seeded replay, scopedUnclear

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. ApexSQL Generate 2022.02.x Release Notes and Requirements

    Current-located release identifier, SQL Server test-data purpose, random/regex/incremental generators, supported SQL Server/Azure SQL/Amazon RDS scope, Windows and SSMS integration.

    Source checked: 2026-10-01
  2. SQL DevOps tools | ApexSQL

    Quest current page places the Generation module within the commercial ApexSQL DevOps toolkit and describes SQL Server data generation, millions of rows, file exports, generators, and FK consistency.

    Source checked: 2026-10-01
  3. Quest Acquires ApexSQL

    Quest acquisition of ApexSQL in 2019; current brand context is Quest/ApexSQL, not independent ApexSQL ownership.

    Source checked: 2026-10-01

Use the same acceptance checks for your shortlist