- Home
- Test Data Generation Tools
- ApexSQL Generate
On the recordRead 8 Oct 202621 facts
ApexSQL Generate
On the record
- Authentication
- The product supports Windows and SQL Server authentication, and its release notes document Active Directory password, integrated, and universal authentication with MFA.support-public.cfm.quest.com · read 8 Oct 2026
- Automation
- ApexSQL Generate can save selected project settings as batch or PowerShell automation scripts.knowledgebase.apexsql.com · read 8 Oct 2026
- 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.knowledgebase.apexsql.com · read 8 Oct 2026
- Database connections
- The product supports SQL Server 2005 and higher, Azure SQL Database, and Amazon RDS for SQL Server.support-public.cfm.quest.com · read 8 Oct 2026
- Database support
- The listed requirements include SQL Server 2005 and higher, Azure SQL Database, and Amazon RDS for SQL Server.support-public.cfm.quest.com · read 8 Oct 2026
- Data consistency
- The toolkit page says the generator retains data consistency with foreign key support and can emulate real-world test data.quest.com · read 8 Oct 2026
- Data types
- It supports SQL data types and can recognize column types in a loaded database to generate corresponding test data.support-public.cfm.quest.com · read 8 Oct 2026
- Evaluation
- ApexSQL sales FAQs state that its software is try-before-you-buy with a minimum 14-day evaluation period.quest.com · read 8 Oct 2026
- Generation controls
- Users can set row counts, random seeds, null-value percentages, and behavior for invalid data.blog.apexsql.com · read 8 Oct 2026
- Generators
- It offers randomized data with Random and Regular expression generators and sequential data with the Incremental generator.support-public.cfm.quest.com · read 8 Oct 2026
- 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.support-public.cfm.quest.com · read 8 Oct 2026
- Notable limit
- The release notes list a minimum requirement of .NET Framework 4.7.2 and administrative privileges for the Windows user account.support-public.cfm.quest.com · read 8 Oct 2026
- Operating system
- The listed operating systems are Windows 7 SP1 and Windows Server 2008 R2 SP1 or higher.support-public.cfm.quest.com · read 8 Oct 2026
- Output formats
- The toolkit page lists SQL, XML, CSV, JSON, and Excel as test data export formats.quest.com · read 8 Oct 2026
- Purpose
- ApexSQL Generate populates SQL databases with test data using multiple generators for each column.support-public.cfm.quest.com · read 8 Oct 2026
- Security and compliance
- Quest lists an Accessibility Conformance Report for ApexSQL Generate and says its reports follow WCAG 2.1 and 2.2.quest.com · read 8 Oct 2026
- SSMS integration
- The listed add-in integration requirement is SQL Server Management Studio 2012 and higher.support-public.cfm.quest.com · read 8 Oct 2026
- Support
- Quest states technical support is available to customers with valid maintenance contracts and trial users.support-public.cfm.quest.com · read 8 Oct 2026
