Freedom251 › Test Data Generation Tools
EMS Data Generator for MySQL

What EMS Data Generator for MySQL is
EMS Data Generator for MySQL creates synthetic test data for MySQL tables on Windows. It can populate several tables, including tables in different databases on one host, while controlling referential integrity for linked tables. Generation supports lists, random values, multiple fields, and SQL query results used as value lists. The maker says all MySQL data types are supported, including ENUM, SET, and GEOMETRY, and users can specify a percentage of NULL values. Data can be saved and edited as an SQL script without executing queries on the server. A console application works from generation templates, while wizard settings can be saved to configuration files and command-line utilities can use template files. There is no free plan, but a fully functional 14-day trial is available. Purchase includes one year of maintenance, updates, upgrades, and technical support.
Who it suits
It suits Windows users who need repeatable synthetic MySQL data for testing across multiple related tables.
What it does well
- Generates synthetic MySQL test data
- Controls linked-table referential integrity
- Supports all listed MySQL data types
- Exports editable SQL scripts
- Fully functional 14-day trial
What to know first
- Windows platform only
- No free plan
- Maintenance renewal starts from 35% yearly
Verdict
EMS Data Generator for MySQL combines multi-table generation, integrity controls, SQL scripts, and template-driven console use. Its Windows-only availability and paid model should be considered alongside the 14-day trial and support terms.
Facts from EMS Data Generator for MySQL's own pages
- Company
- EMS Software Development says it was founded in 1993 and has focused on database administration tools and data management utilities since 1999. · sqlmanager.net, 9 Oct 2026
- Configuration
- Generation parameters from a wizard session can be saved to a configuration file, and the command-line utility can use a template file. · sqlmanager.net, 9 Oct 2026
- Console use
- A console application can generate data in one touch using generation templates. · sqlmanager.net, 9 Oct 2026
- Console utility
- A console application can generate MySQL test data using generation templates. · sqlmanager.net, 9 Oct 2026
- Data types
- The maker says all MySQL data types are supported, including ENUM, SET, and GEOMETRY. · sqlmanager.net, 9 Oct 2026
- Generation methods
- It supports list and random generation, generation across multiple fields, and SQL query results as value lists. · sqlmanager.net, 9 Oct 2026
- Integrity and nulls
- The product offers automatic referential integrity control for linked tables and lets users set a percentage of NULL values. · sqlmanager.net, 9 Oct 2026
- Maintenance and support
- The maker says purchases include one year of maintenance, updates and upgrades, and unlimited technical support during the maintenance period. · sqlmanager.net, 9 Oct 2026
- Maker
- EMS Software Development says it was founded in 1993 and has focused on database administration tools and data-management utilities since 1999. · sqlmanager.net, 9 Oct 2026
- Multiple databases
- It can generate data in several tables from different databases on one host. · sqlmanager.net, 9 Oct 2026
- Multi-table generation
- It can populate several MySQL tables, including tables in different databases on one host. · sqlmanager.net, 9 Oct 2026
- Purchase and maintenance
- The product page states that purchase includes one year of maintenance, updates and upgrades, and technical support; renewal is listed as starting from 35% per year. · sqlmanager.net, 9 Oct 2026
- Purpose
- EMS Data Generator for MySQL generates test data for MySQL tables and can save and edit scripts. · sqlmanager.net, 9 Oct 2026
- Referential integrity
- The product automatically controls referential integrity for linked tables. · sqlmanager.net, 9 Oct 2026
- Refund policy
- The maker lists a 30-day money-back guarantee. · sqlmanager.net, 9 Oct 2026
- Script generation
- Generated data can be saved in an SQL script without executing queries on the server. · sqlmanager.net, 9 Oct 2026
- SQL query values
- SQL query results can be used as lists of values for data generation. · sqlmanager.net, 9 Oct 2026
- SQL scripts
- Generated data can be saved and edited in an SQL script without executing queries on the server. · sqlmanager.net, 9 Oct 2026
- Support
- EMS provides online support through its support ticket system and says tickets receive a unique number for processing by its support team. · sqlmanager.net, 9 Oct 2026
- Support channel
- EMS provides online support through its support ticket system. · sqlmanager.net, 9 Oct 2026
- Trial
- The maker offers a fully functional 14-day free trial. · sqlmanager.net, 9 Oct 2026
Where EMS Data Generator for MySQL stands on Freedom251
- Test Data Generation Tools#26 of 28