Online Documentation for Data Generator for SQL Server
Setting general options
This page allows you to define general options of the application.
Select the main color theme for the application: Light or Dark.
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.
Set NULL value in ... % of cases
This option allows you to specify the percentage of records that will remain NULL by default.
Confirmation on exit
Enables/disables confirmation upon exiting the program.
All columns selected by default
Check this option to include all columns into the data generation process by default.
BLOB columns selected by default
Uncheck this option if you need to exclude BLOB columns from the generation process by default.
Clear tables before generation
Set this option to empty tables before data generation.
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.
Disable identity columns by default
When this option is checked the SET IDENTITY_INSERT OFF statement is generated on the server before data generation.