Test Data Generator
|Previous Top Next|
( Pro Edition )
Once near finishing your database structure, you also need to fill it with data in order to test your applications. Unlike most tools, Database Workbench comes equipped with a fully features Test Data Generator (TDG) tool which generates meaningful data and can use custom data as well. Do read the "notes" at the bottom of this page.
Also have a look at the command-line Test Data Generator.
Test Data Generator - screen layout
The Test Data Generator has 3 distinctive parts -
These parts are used to edit/create filler instructions. This has to be done before trying to fill your database with data.
You can start the filling process by clicking the green Run button - the default action is to create a second connection to your database and use that connection to create the data. This way, you can continue working in Database Workbench. If you ran out of allowed user connections, or don't mind stalling Database Workbench (you can always start second instance of the application), you can click the small arrow besides the button and choose the Start Filling - Non Threaded menu-item.
The Load Settings From File and Save Settings From File can be used to load and store your filler instructions. These files can also be used with the command-line version of the TDG, for example to run a filler-process during the night to generate huge amount of rows while you're not waiting.
In part 1, you will see your database schema - it will show the table columns, NULLability and primary key columns. Here you can also tell the TDG to fill a table by checking the box left of the table name.
You can move a table up/down in the filling sequence by clicking the blue arrow buttons at the top of the screen.
Test Data Generator - some columns are being filled
As you can see in the above example, table ADRES is being filled with 10000 rows and columns ADRES2 and POSTCODE are not being filled yet.
By selecting a column, the appropriate settings for that particular data type become enabled in the Column Settings Area. After you've entered the filler settings, a green check mark will appear - as you can see in the above example.
The Table Settings Area holds the following settings:
Any disabled indices and/or triggers will be re-enabled after completion of the filling process.
The area where you change the column-filling settings. Depending on the data type, several filling options are available. Below is a fill-option availability matrix:
Each NULLable column allows a percentage of NULL values, for non-NULL columns, this is of course disabled.
The "Complex Custom Value" ("masked value") is a special way of filling and very powerful, it is reached by selecting Random Value from the drop down. This will show the following part of the screen:
Random Value - Complex Custom Value
As you can see in the above screen, for character data, there's a lot of possibilities. Below is a description of each of the possibilities: