Using Generators

Last modified: October 18, 2023

dbForge Studio for MySQL provides a collection of generators to create different column values for the tables you want to populate.

The following basic data generators are available:

Constant Generator
Files Folder Generator
Foreign Key (auto assigned) Generator
Foreign Key (manually assigned) Generator
JSON Generator
Lorem Ipsum Generator
Regular Expression Generator
Shuffled Text Generator
SQL Query Generator
String Generator
Table or View Generator
Text File Generator
Twaddle Generator
Uniqueidentifier Generator
Weighted List Generators

In addition to basic generators, dbForge Studio for MySQL provides 90+ meaningful generators, including advanced generators, and user-defined generators.

To select a generator for a column

In the Tables and columns to populate pane, click a column.
In the Column generation settings pane, select a generator type from the Generator drop-down list box.

Note

The Generator list features only those generators that are compatible with data type of the selected column.

(Optional) In the Fill Settings section of the Column generation settings pane, customize the default value generation settings. The array of settings depends on the generator type.