Skip to content
SPECIFICTION
Get listed

ApexSQL Generate

apexsql.com

Free trial WindowsSelf-hosted
Visit apexsql.com
Spec score 8.0 #5 of 28 in Test Data Generation Tools

Spec sheet

Purpose
ApexSQL Generate populates SQL databases with test data using multiple generators for each column.Read 8 Oct 2026 · support-public.cfm.quest.com
Trial
Quest offers a free trial of the ApexSQL DevOps Toolkit, which includes ApexSQL Generate.Read 8 Oct 2026 · quest.com
Support
Quest states technical support is available to customers with valid maintenance contracts and trial users.Read 8 Oct 2026 · support-public.cfm.quest.com
Authentication
The product supports Windows and SQL Server authentication, and its release notes document Active Directory password, integrated, and universal authentication with MFA.Read 8 Oct 2026 · support-public.cfm.quest.com
Automation
ApexSQL Generate can save selected project settings as batch or PowerShell automation scripts.Read 8 Oct 2026 · knowledgebase.apexsql.com
CI use
ApexSQL documents using Generate in a CI workflow to populate a database with test data, with 100 rows inserted by default when RowCount is omitted.Read 8 Oct 2026 · knowledgebase.apexsql.com
Data consistency
The toolkit page says the generator retains data consistency with foreign key support and can emulate real-world test data.Read 8 Oct 2026 · quest.com
Data types
It supports SQL data types and can recognize column types in a loaded database to generate corresponding test data.Read 8 Oct 2026 · support-public.cfm.quest.com
Database connections
The product supports SQL Server 2005 and higher, Azure SQL Database, and Amazon RDS for SQL Server.Read 8 Oct 2026 · support-public.cfm.quest.com
Database support
The listed requirements include SQL Server 2005 and higher, Azure SQL Database, and Amazon RDS for SQL Server.Read 8 Oct 2026 · support-public.cfm.quest.com
Evaluation
ApexSQL sales FAQs state that its software is try-before-you-buy with a minimum 14-day evaluation period.Read 8 Oct 2026 · quest.com
Generation controls
Users can set row counts, random seeds, null-value percentages, and behavior for invalid data.Read 8 Oct 2026 · blog.apexsql.com
Generators
It offers randomized data with Random and Regular expression generators and sequential data with the Incremental generator.Read 8 Oct 2026 · support-public.cfm.quest.com
Known limitation
The 2020.02 release notes state that the application's add-in menu is not shown under the ApexSQL menu in SSMS 2012 and 2014.Read 8 Oct 2026 · support-public.cfm.quest.com
Notable limit
The release notes list a minimum requirement of .NET Framework 4.7.2 and administrative privileges for the Windows user account.Read 8 Oct 2026 · support-public.cfm.quest.com
Operating system
The listed operating systems are Windows 7 SP1 and Windows Server 2008 R2 SP1 or higher.Read 8 Oct 2026 · support-public.cfm.quest.com
Output formats
The toolkit page lists SQL, XML, CSV, JSON, and Excel as test data export formats.Read 8 Oct 2026 · quest.com
Security and compliance
Quest lists an Accessibility Conformance Report for ApexSQL Generate and says its reports follow WCAG 2.1 and 2.2.Read 8 Oct 2026 · quest.com
SSMS integration
The listed add-in integration requirement is SQL Server Management Studio 2012 and higher.Read 8 Oct 2026 · support-public.cfm.quest.com
Telemetry
A 2020 release added anonymous collection of application and component usage and performance telemetry.Read 8 Oct 2026 · support-public.cfm.quest.com
Test data scale
The ApexSQL DevOps Toolkit page says its Generation module can generate test data for specified tables, including millions of rows.Read 8 Oct 2026 · quest.com

Where Specifiction places it

Alternatives to ApexSQL GenerateAll alternatives →