ApexSQL Generate
5.8#15 in test data generation toolsSelf-hostedWindows
VisitApexSQL Generate vs Mockaroo
What both publish
| Fact | ApexSQL Generate | Mockaroo |
|---|---|---|
| Data types | It supports SQL data types and can recognize column types in a loaded database to generate corresponding test data. | The Mock APIs page says users can choose from more than 100 built-in data types, upload reference data, or build data types with the formula API. |
| Notable limit | The release notes list a minimum requirement of .NET Framework 4.7.2 and administrative privileges for the Windows user account. | The Generate API documentation says synchronous responses are limited to 5,000 records regardless of plan; background generation requires a paid plan. |
| Output formats | The toolkit page lists SQL, XML, CSV, JSON, and Excel as test data export formats. | The Generate API supports JSON, CSV, tab-separated text, custom-delimited text, SQL, and XML output. |
| Purpose | ApexSQL Generate populates SQL databases with test data using multiple generators for each column. | Mockaroo generates realistic test data and can create mock back-end APIs for UI development. |
| Support | Quest lists ApexSQL Generate among the products with support options in the ApexSQL DevOps Toolkit Bundle. | Mockaroo directs users with questions to its Community Forum so answers can benefit everyone. |
ApexSQL Generate plans
No prices published.
Mockaroo plans
- FreeFree
- Silver$60 a year
- Gold$500 a year
- Enterprise$7,500 a year
Pick ApexSQL Generate if…
It suits Windows teams generating relational test data for supported SQL Server environments, including CI workflows and large table populations. Developers who need configurable synthetic values and export formats may find its controls useful.
Pick Mockaroo if…
Mockaroo suits developers and testers who need realistic sample records or mock APIs. Front-end developers can use it while a back end is not yet ready.