EMS Data Generator for MySQL

What is EMS Data Generator for MySQL?

EMS Data Generator for MySQL is an impressive tool for generating test data in MySQL database tables with the ability to save and edit scripts.

The utility can help you simulate the database production environment and lets you populate multiple MySQL database tables with test data simultaneously, define tables and fields to generate data, set ranges of values, generate MySQL character fields by mask, set value lists manually, or select them in SQL queries,  set generation parameters for each field type and has many other features to generate MySQL test data simply and directly. Data Generator for MySQL also provides a console application, which allows you to generate MySQL test data in one touch, using generation models.

Core features

• Unicode support.
• Wizard-friendly interface.
• Ability to save and edit data generated in sql script without running queries on the server.
• Generating data on multiple tables of different databases on a host.
• All types of MySQL data support, including the ENUM, SET, and GEOMETRY types.
• Different generation types for each field, including list and random generation, generation in two and more fields simultaneously.
• Ability to use SQL query results as a list of values for data generation.
• Ability to view the generated data.
• Automatic referential integrity control for linked tables.
• Wide variety of generation parameters for each field type.
• Ability to set NULL values for a given percentage of cases.
• Ability to save all generation parameters defined in the current wizard session in a configuration file.
• Command-line utility for generating data using the template file.

System Requirements

Microsoft Windows XP, Microsoft Windows Server 2003, Microsoft Windows Server 2008, Microsoft Windows Server 2008 R2, Microsoft Windows Server 2012, Microsoft Windows Server 2012 R2, Microsoft Windows Server 2016, Microsoft Windows Vista, Microsoft Windows 7, Microsoft Windows 8 / 8.1, Microsoft Windows 10

20 MB of available HD space for program installation

Possibility to connect to any local or remote MySQL server