EMS Data Generator for MySQL vs Mockaroo
EMS Data Generator for MySQL
sqlmanager.netMockaroo
mockaroo.comSide by side
| Figure | EMS Data Generator for MySQL | Mockaroo |
|---|---|---|
| Price from | — | $5/mo |
| Free plan | — | Yes |
| Free trial | Yes | Yes |
| Open source | — | — |
| Web | — | Yes |
| Windows | Yes | — |
| API | — | Yes |
| Self-hosted | — | Yes |
| Plans published | 0 | 4 |
| Spec score · Test Data Generation Tools | 7.6 (#14) | 7.9 (#7) |
| Data types | The maker says all MySQL data types are supported, including ENUM, SET, and GEOMETRY. | 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. |
| Purpose | EMS Data Generator for MySQL generates test data for MySQL tables and can save and edit scripts. | Mockaroo generates realistic test data and can create mock back-end APIs for UI development. |
| Support | EMS provides online support through its support ticket system and says tickets receive a unique number for processing by its support team. | Mockaroo directs users with questions to its Community Forum so answers can benefit everyone. |
Plans
In their own words
EMS Data Generator for MySQL
EMS Data Generator for MySQL 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.