EMS Data Generator for MySQL

EMS Data Generator for MySQL is an utility for generating test data to several MySQL database tables at once. The wizard application allows to define tables for generating data, set value ranges, generate char fields and blobs, and many other.

Features: MS Data Generator for MySQL is a tool for generating test data to MySQL database tables. You would be able to save and edit the scripts.The utility helps simulate the database production environment. You would be able to populate several tables with test data at the same time. To do this you can define tables and fields for generating data. There are several other things that you can set. These include the ability to set value ranges, generate MySQL char fields by mask and define lists of values manually. You can select the values from SQL queries too. You can set generation parameters for each field type and such other features to be able to generate test data in a simple yet direct method.

Data Generator for MySQL also provides a console application. The console lets you generate MySQL data in one-touch fashion using templates. The wizard like interface lets you create data for several tables on different databases at one host. Different types generated include all data types including ENUM and SET types.Data generators for different types includes list, random, incremental data generation and more. You could also use SQL query results as a list of values for data generation. Referential integrity of linked tables data generation can be controlled automatically. You can save all the generation parameters of a particular session for future use. Unicode is supported and you can preview the data that is generated.

Overall: Useful generator for testing MySQL databases.

EMS Data Generator for MySQL is a powerful utility for generating test data to several MySQL database tables at once. The wizard application allows you to define tables and fields for generating data, set value ranges, generate char fields by mask, load values for BLOB fields from files, get lists of values from SQL queries and many other features to generate test data in a simple and direct way. It also provides you console application, which allows you to generate data in one-touch by using generation templates.
Features:
- User-friendly wizard interface;
- Generating data to several tables from different databases on one host;
- All MySQL data types support including ENUM and SET types;
- Different generation types for each field including list, random, incremental data generation and more;
- Ability to use SQL query results as list of values for data generation;
- Automatic control over referential integrity for linked tables data generation;
- Wide variety of generation parameters for each field type;
- Ability to set NULL values for certain percent of cases;
- Possibility of saving all the generation parameters, set on current wizard session;
- Command-line utility to generate data using the template file.