The tool supports a massive range of column data types, including:
INTEGER, DECIMAL, NUMERIC, FLOAT
TIME, DATE, DATETIME, YEAR
CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT
ENUM, SET, JSON
All spatial data types
Multiple generators with data customization
Data Generator comes with individual generators for each supported data type, that allow to
Number of NULL rows
Number of empty rows
Value distribution mode
SQL data integrity support
The tool supports foreign keys for generation of consistent data across multiple tables.
It also allows disabling triggers and constraints to avoid interference with database logic.
Multiple ways to populate data
The generated data population script that can immediately be executed against a MySQL database,
saved for the future use or edited in the internal editor.
With collection of basic generators, you can populate tables with various types of values.
The tool includes the following generators:
Table or View
dbForge Data Generator for MySQL includes 180+ generators, that allow to populate tables with realistic-looking test data. In particular,
tool can fill your tables with:
Credit card numbers
and much more!
You can create, save, and use your own generators that would better meet your needs,
instead of customizing existing generators over and over again.
Real-time preview of generated data
A convenient preview pane gives you real-time visualization of the changes you
make while you adjust data generation settings. This gives you an opportunity to
quickly make visual assessment of the data that will be generated.
With the command-line functionality, you can save time by scheduling routine data generation tasks.