Includes predefined data generators Preview of generated test data Generate custom test data generators Possibility of data generators customization Supports all data types Supports a number of database server versions
Cons
None
DbForge Data Generator for MySQL
Price: $
Generate various kinds of test data for MySQL, Percona and MariaDB databases, using dbForge Data Generator for MySQL. It includes a variety of predefined data generators and there is also a possibility to create your own.
Predefined data generators include data generators for different topics, including health, business, personal data and others. Besides data generators that are specific to a topic, there are also some basic data generators included, which can generate random strings, use SQL queries to populate tables, load data from text files and perform other various types of database population methods.
Generated test data can be previewed in the convenient pane, so you will be able to adjust your data generation options more accordingly. If none of the predefined generators suits your needs, you can also generate your own test data generators, by creating and editing XML files.
Generators offer many customization options and support all data types, including numeric values, strings, dates and others. dbForge Data Generator for MySQL also takes foreign keys into consideration when generating test data, thus making sure the data generation process is consistent across all tables.
Test data can be populated to target database instantly, and it can also be displayed in SQL editor window and saved to a file. A command-line interface can also be used for automatic generation of test data on regular basis.
In conclusion, a comprehensive and professional tool for populating unlimited amounts of test data to MySQL, Percona and MariaDB databases, with a number of database server versions supported.
Reviewed by Tony Hill (editor rating 4 out of 5 stars)