Setting general options

This page allows you to define general options of the application.

Number of records to generate

Sets the quantity of records generated by default.

Commit every ... records

Specifies the number of records in each block of the generation script to be supplemented with the COMMIT statement.

Number of records to preview

Sets the quantity of records used in the Data Preview window by default.

Confirmation on exit

Enables/disables confirmation upon exiting the program.

All fields selected by default

Check this option to include all fields into the data generation process by default.

BLOB fields selected by default

Uncheck this option if you need to exclude BLOB fields from the generation process by default.

Clear tables before generation

Set this option to empty tables before data generation.

Save passwords

Setting this option allows you to save passwords used for access to the databases automatically upon closing the application. Please note that checking this option saves the latest password used for connection to the database.

Show DDL for table in hint

This option enables/disables hints that popup when the mouse cursor is positioned over the table names within the Generate Data for area at Step 3.

Show databases

This option enables/disables the 'Select Database' drop-down list at Step 2 of the wizard. If you check this option, you can select the database from the list, otherwise you must type the database name manually.

Disable identity fields by default

When this option is checked the SET IDENTITY_INSERT OFF statement is generated on the server before data generation.