We do not supply this product anymore.

ApexSQL Generate

Test data generation specifically designed for SQL Server developers.

Published by ApexSQL
Distributed by ComponentSource since 2006

Version: 2018.04 Updated: Jun 21, 2019


ApexSQL was acquired by Quest Software in Apr 2019, this means that from Nov 2019 ApexSQL products are no longer available from ComponentSource. If you would like to buy or renew an ApexSQL product please contact Quest Software here: https://www.apexsql.com/ or if you would like to find an alternative product please see our Database Administration products or Contact Us for further assistance.

ApexSQL Generate

ApexSQL Generate generates test data for specified columns and tables. It exports test data to SQL, XML, and CSV files, or executes it directly against the database. Use a wide range of predefined options to customize the data, like setting the seed, length, minimum and maximum values, uniqueness of data, and percentage of null values. Preview generated data before executing or exporting. With ApexSQL Generate you can quickly generate millions of rows of test data. Use different generators such as Random, Incremental, From list, From table, From directory, From query, and From CSV. It has intelligent auto-creating of data patterns at row level, supports a wide variety of data types, including geography, money, and hierarchyid.

ApexSQL Generate Benefits:

  • Generate SQL test data for specified tables.
  • Export test data to SQL, XML, CSV.
  • 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.

Latest News

ApexSQL Generate 2018.04
ApexSQL Generate 2018.04
Adds Active Directory support for Integrated, Password and Universal with MFA support.
ApexSQL Generate 2018.02
ApexSQL Generate 2018.02
Adds SQL Server Management Studio 18 integration, plus support for SQL Server 2019 CTP 2.0.
ApexSQL Generate 2018.01
ApexSQL Generate 2018.01
Adds support for High DPI and 4K resolution, plus new CLI switches.
ApexSQL Generate 2017.02
ApexSQL Generate 2017.02
Adds granularity option to create one SQL script, or one SQL script per object.
ApexSQL Generate 2017.01
ApexSQL Generate 2017.01
Adds support for SQL Server on Amazon RDS, SQL Server 2017 CTP 2, plus new GUI themes.
ApexSQL Generate 2016.05
ApexSQL Generate 2016.05
3 new CLI switches, usability improvements and improved quality.
One software license is required per user. This means that one user needs one license, regardless the number of computers he/she uses (within reason). If a single developer/DBA works on multiple...

ApexSQL Generate is also available in:


We no longer sell ApexSQL products, please visit their web site instead.

Operating System for Deployment
  • Windows 10
  • Windows 8.1
  • Windows 8
  • Windows Server 2012
  • Windows 7
  • Windows Server 2008
  • Windows Vista

Recent Awards