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

Features

Full SQL data types support

Generators cover all SQL 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

Customization

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 generator

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

Bypass triggers and Check constraints

Disable Insert and Delete 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

Exports

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

Notify errors, warnings and info messages in 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 plan

Build inheritance into test data plans by copying existing database settings

See next feature

Full Command Line Interface support

Automate data generation process with more flexibility. Learn more

See next feature

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 Generate 2016 – Screen shot tour

This article represents a screen shot tour of ApexSQL Generate features with a brief description

See more
ApexSQL Redgate®
Inputs
      CSV or TXT
      Custom list
      Directory
      SQL table or view
Outputs
      Direct execution against database
      CSV
      Excel
      JSON
      SQL static data
      XML
Integration
      SQL Server Management Studio (SSMS)
Generators
      Cross-column generator
      Foreign key generator
      Generic (Random, incremental, regular expresion, text shuffler)
      IronPython script
      Table mapping
      Shareable user-defined generator
      Predefined generator 150+ types 60 types
      Text generator (Lorem ipsum, sentence generator)
Other
      Action plan and post-generation summary
      Command line interface
      Disable constraints and triggers prior to generation
      GUI warnings
      Pre-processing and post-processing scripts
      Applying settings to child objects
      Include/exclude dependent tables
      Visual dependencies
Price
$499 $369

ApexSQL Generate 2016.02

Redgate® SQL Data Generator 3.1


Comparison was conducted on February 26, 2016

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

Save a bundle

ApexSQL Generate is included in ApexSQL Developer

15 ApexSQL developer tools

Priority support

1 year free support and upgrades

New products added for free

Combined 75% savings