You'll receive

Bi-weekly updates

Exclusive discounts

Product update alerts

Generate SQL test data for specified tables
Export test data to SQL, XML, CSV, JSON, Excel
Generate millions of rows quickly
Customize test data plan with detailed options
Support a full range of SQL data types
Choose from multiple generators (Random, List, etc.)
Retain data consistency with foreign key support
Emulate real-world test data


Full SQL Server data type support

Generate test data across all SQL Server data types

See next feature

Predefined generators

Use 150+ predefined generators for meaningful data e.g. names, addresses, credit card numbers, social security numbers

See next feature

Cross-column dependency support

Generate test data based on another column’s values with predefined conditional, string, date and numeric functions

See next feature


Use a wide range of predefined options to customize data, like seed, length, minimum and maximum values, uniqueness of data, and percentage of null values. Learn more

See next feature

User defined generators

Save any generator’s settings so it can be reused later with already prepared setup. Learn more

See next feature

Table mapping

Use intelligent column recognition pattern to populate table with data from external sources like other database tables and views or CSV files. Learn more

See next feature

Trigger and Check constraint handling

Disable Triggers and Check constraints to avoid referential integrity errors

See next feature

Relational integrity support

Include or exclude dependent objects in the generation process

See next feature


Execute the generated data against a database or choose one of the exporting options

See next feature

Generated data preview

Preview generated data before executing or exporting

See next feature

GUI warnings

Display errors, warnings and info messages in the tree view and preview panel for incorrect generator settings, circular dependencies, constraint violations, info messages regarding DELETE triggers enforced for the selected column and more

See next feature

Post generation summary

Track progress, possible errors and the number of rows successfully inserted into the database and the time span of the generation process

See next feature

Modular test plans

Build inheritance into test data plans by copying existing database settings

See next feature

Command Line Interface

Fully automate the test data generation process. Learn more

See next feature

Note: All screenshots shown belong to the upcoming version of the tool – ApexSQL Generate 2018


Note: All screenshots shown belong to the upcoming version of the tool – ApexSQL Generate 2018

How to use regular expressions (RegEx) in SQL Server to generate randomized test data

This article describes how to generate test data using the Regular expression generator in ApexSQL Generate

How to generate randomized test data from a CSV file

In this article, we describe how to generate large amounts of randomized data from the imported CSV formatted file

ApexSQL Generate Command Line Interface (CLI) switches

This article explains the ApexSQL Generate CLI switches and their usage through the examples

How to generate sequential data in ApexSQL Generate

This article explains how to generate sequential data in ApexSQL Generate by using the Incremental generator and shows some special cases regarding the settings of this generator

How to generate randomized test data in ApexSQL Generate

This article explains how to generate randomized data in ApexSQL Generate by using the Random generator. Also, it shows how it works for basic SQL data types

ApexSQL Redgate ®
Community Standard Professional
SQL Server editions
      Amazon RDS for SQL Server
      Azure SQL Database
      Live database
      SQL script
      Direct execution against database
      SQL script
      SQL Server Management Studio (SSMS)
General features
      Action plan and post-generation summary
      Table mapping
      Pre and post-processing scripts
      Visual dependencies
      Test data preview (CSV, JSON, SQL, XML)
      Foreign key
      Generic (Random, incremental, regular expresion, text shuffler)
      Predefined generator 150+ types 60 types
      Shareable user-defined
      Weighted list (nested and regex)
      CSV file
      Text generator (Lorem ipsum, sentence generator)
      Command Line Interface
      Save as batch
Free $299 $499 $369

ApexSQL Generate 2017.01

Redgate® SQL Data Generator 3.1

Comparison was conducted on July 12, 2017

Disclaimer: All product and company names are trademarks or registered® trademarks of their respective holders.
ApexSQL is not affiliated, associated, authorized, endorsed by, or in any way officially connected with other companies listed or any of their subsidiaries or affiliates

ApexSQL Generate is part of the

ApexSQL CI/CD toolkit

Volume pricing



















Save a bundle

ApexSQL Generate is included in ApexSQL Developer

19 ApexSQL developer tools

Priority support

1 year free support and upgrades

New products added for free

Combined 80% savings