How Does DB Data Generator Work?

You can use DB Data Generator to fill a database with test data that is appropriate for the database schema of the database. You can generate random data, generate data from existing data sources, and control many aspects of data generation.

Select a Database to Fill With Test Data

With DB Data Generator you connect to a database and select the tables you want to fill with test data. You can populate empty tables, or add extra rows to your existing data. DB Data Generator will then create a data generator project for you and will read in the database schema.

Configure Data Generators for Columns

After connecting to the database, DB Data Generator will automatically configure the data generation settings for each column. This information is the core of the data generation plan. You can now optionally customize the selected data generators and changing the default properties for each column. You control exactly what data is generated to fill each column.

Pre-defined Standard Data Generators

DB Data Generator includes a variety of pre-defined standard data generators. You can use the standard data generators to generate random data for columns. For example, if you have an int column, you can use the Random Integer data generator to create random data for the column. Every data type has a default data generator that is associated with it. The default data generator for a column is automatically assigned to columns that have a particular combination of data type, constraint, name and/or link to another table. The default generator is also assigned when you add columns to the project. You can also use external sources as other database tables or CSV files as input for a column.

Generate Test Data

Start generating test data by clicking the Generate test data button and choose where to save the generated data: Insert the data directly into the database or generate a SQL file with insert statements. DB Data Generator will now generate data for the selected tables. DB Data Generator takes dependencies into account when defining the order in which data will be generated.

Reuse Your Data Generation plan

A DB Data Generator project holds information like tables, column, relationships between tables and the table and field settings (fill method etc). Each project indicates which database to fill with data and how this data will be generated.