ApexSQL Generate vs Mockaroo
ApexSQL Generate
apexsql.com
Mockaroo
mockaroo.comSide by side
| Figure | ApexSQL Generate | Mockaroo |
|---|---|---|
| Price from | — | $5/mo |
| Free plan | — | Yes |
| Free trial | Yes | Yes |
| Open source | — | — |
| Web | — | Yes |
| Windows | Yes | — |
| API | — | Yes |
| Self-hosted | Yes | Yes |
| Plans published | 0 | 4 |
| Spec score · Test Data Generation Tools | 8.0 (#5) | 7.9 (#7) |
| 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 states technical support is available to customers with valid maintenance contracts and trial users. | Mockaroo directs users with questions to its Community Forum so answers can benefit everyone. |
Plans
In their own words
ApexSQL Generate
ApexSQL Generate has no write-up on Specifiction yet; its figures are above.
Mockaroo
Mockaroo is a web-based synthetic data generator for developers and testers who need realistic test records or a mock back end while building a user interface. It offers more than 100 built-in data types; users can also upload reference data or define types with the formula API. The Generate API produces JSON, CSV, tab-separated or custom-delimited text, SQL, and XML. Mock APIs can connect request parameters to schemas and return dynamic or static data, or simulate errors. Both APIs require an API key, sent as a query parameter or an X-API-Key header. Free includes 1,000 rows per file and 200 API requests per day. Silver is $60 a year and allows 100,000 rows per file and 1 million API records per day; Gold is $500 a year and allows 10 million rows per file and 10 million API records per day. Synchronous API responses are limited to 5,000 records on every plan; background generation requires a paid plan. Enterprise is $7,500 a year, with unlimited data and users and Docker deployment in a private cloud or datacenter.