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.

Product status changed

When should you consider it?

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

Editorial fit assessment based on the sources below.

What are the limits?

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.

Which capabilities are documented?

Synthetic generationDocumented ยท source
De-identification / maskingNot verified
Subsetting / subset planningNot verified
Data virtualizationNot verified
Seeded replay, scopedNot verified

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?

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.

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

Sources and scope

  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

What should you verify in a proof of concept?

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