Below is a fill-option availability matrix: Depending on the data type, several filling options are available. The area where you change the column-filling settings. Disabling indices can speed up the filling (default: True).Ĭheck this to disable any user-defined triggers on the table in order to avoid things to happen behind the screen (default: True).Īny disabled indices and/or triggers will be re-enabled after completion of the filling process. (default: False).Ĭheck this to disable any user-defined indices, primary key and other constraint-related indices will not be disabled. This can improve the speed of the filling, as the database engine doesn't need to keep track of hundreds of thousands of rows in a single transaction (default: 1000).Ĭheck this if you want to delete all rows before generating new ones - this will fail if there are referential constraints and it will abort the complete process if this happens. If errors occur during filling, less rows will be created (default: 10000).Īll rows can be generated in a single transaction, or after each number of rows, a transaction will be committed. The amount of rows to generate for this table. The Table Settings Area holds the following settings: After you've entered the filler settings, a green check mark will appear - as you can see in the above example.
Does recompiling reset a random sequence generator generator#
Test Data Generator - some columns are being filledĪs 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.īy selecting a column, the appropriate settings for that particular data type become enabled in the Column Settings Area. You can move a table up/down in the filling sequence by clicking the blue arrow buttons at the top of the screen. Here you can also tell the TDG to fill a table by checking the box left of the table name. In part 1, you will see your database schema - it will show the table columns, NULLability and primary key columns. 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. The Load Settings From File and Save Settings From File can be used to load and store your filler instructions. 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. This way, you can continue working in Database Workbench.
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 has to be done before trying to fill your database with data. These parts are used to edit/create filler instructions.
0 kommentar(er)
