dbForge Data Generator for MySQL Features

This page provides a comprehensive listing of features available in dbForge Data Generator for MySQL. For a list of new features see What's New in 1.6.

Full support of all MySQL column data types

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 customize:

  • Number of NULL rows
  • Number of empty rows
  • Data uniqueness
  • Value ranges
  • 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.

Basic generators

With collection of basic generators, you can populate tables with various types of values. The tool includes the following generators:

  • Regular Expression
  • Weighted Lists
  • SQL Query
  • Table or View
  • Text File
  • Files Folder
  • Shuffled Text
  • Lorem Ipsum
  • Python

Meaningful generators

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:

  • IDs
  • Post codes
  • Phone numbers
  • Countries
  • Credit card numbers
  • E-mails
  • and much more!

User-defined generators

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.

Command-line interface

With the command-line functionality, you can save time by scheduling routine data generation tasks.