EMS Data Generator for MySQL is a software tool that generates test data for multiple MySQL database tables simultaneously. Its wizard-based interface enables users to specify table settings, data ranges and more, making it ideal for generating sample data for testing purposes.
The software's console application offers one-touch data generation by utilizing generation templates. This feature augments the user's options and offers a more efficient mode of generation. The user-friendly wizard interface ensures that users can easily navigate the software and generate precise results to their satisfaction. All MySQL data types, including ENUM and SET types, are supported.
The software offers different generation types for each field, such as list, random, incremental data generation, and much more. There is an ability to use SQL query results as a list of values for data generation, and automatic control over referential integrity for linked tables data generation. A wide variety of generation parameters for each field type is available.
EMS Data Generator for MySQL boasts the ability to set NULL values for certain percent of cases. This feature ensures that the user has full control over the data generated. The software is also flexible enough to save all the generation parameters set on the current wizard session. Users can also utilize the command-line utility to generate data using the template file.
In summary, EMS Data Generator for MySQL is a powerhouse of software that offers many unique features to generate test data. The software is user-friendly, flexible, and offers a variety of options to suit the user's need. It is a must-have utility for effective test data generation for multiple MySQL database tables.
Version 3.0:
Unicode support is implemented.
Added new options for data generation to SQL script.
Added options for generating the same data into several columns.
Added options for generating string data according to the sample text.
Data preview is implemented.
Version 2.3:
- Improved data generation for tables with Foreign keys.
- The order the tables are cleared has been corrected according to their dependencies.
- Generation data for arrays (Interbase/Firebird.
- Implemented Private Key support for SSH authentication.
- Other improvements and bugfixes.
Version 2.2: Added the opportunity to connect through SSH and HTTP tunnels, new data generation options and speed improvements...