Online Documentation for Data Generator for SQL Server

Configuration file format


The configuration (template) file used by Data Generator for SQL Server is divided into several sections, each corresponding to a particular group of settings specified at different steps of the GUI application wizard.

 

[#General#]

This section stores general information about the utility:

 

Parameter

Description

Product

internal product name

Version

major version

 

 

[#Comment#]

This section stores the template file comment as specified optionally in the Save template options dialog:

 

Parameter

Description

Line<N>

comment text

where N stands for the comment line identifier

 

Example:

Line0=Data Generator for SQL Server

Line1=Template file

Line2=Data generation #1

 

 

[CONNECTION]

This section stores connection parameters to SQL Server. The parameters correspond to the values entered at Step 1 of the Wizard application and are obligatory.

 

Parameter

Description

Host

host/instance where the database resides

Remote

0 = local connection

1 = remote connection

Login

SQL Server login (if NTAuth = 0)

Password

password to identify SQL Server login (encrypted)

NTAuth

0 = SQL Server authentication

1 = Windows authentication

ConnTimeout

connection timeout

Major

major version used to encrypt the passwords (the value must not be changed)

Minor

minor version used to encrypt the passwords (the value must not be changed)

PassPhrase

the parameter is not used by Data Generator for SQL Server

 

[ADDITIONAL]

The section contains additional settings specified at Step 2 and Step 4 of the Wizard application.

 

Parameter

Description

TablesCount

number of tables selected for data generation

SqlExecute

corresponds to the Execute statements option of the Action radio group available at Step 4:

1 = enabled

0 = disabled

SqlSave

corresponds to the Save data generation script to file option of the Action radio group available at Step 4:

1 = enabled

0 = disabled

SaveFile

path to the script file (if SqlSave = 1)

BlobFile

the parameter is not used by Data Generator for SQL Server

ExportBlobType

the parameter is not used by Data Generator for SQL Server

 

 

[TABLE_XX]

The section is repeated for all tables; the settings are specified at Step 3 of the Wizard application.

 

Parameter

Description

Database

indicates the name of the database where the table is located

TableName

indicates the name of the table to generate data into

RecordCount

number of records to be generated

ClearBeforeGeneration

1 leads to emptying table

0 leaves the table as it was before data generation

 

[TABLE_XX_FIELD_YY]

The section is created for each field of each table.

 

Parameter

Description

DoGenerate

0 indicates that the field is excluded

1 indicates that the field is included

IncludeNulls

1 specifies that the NULL values are set for certain percent of cases

0 disables this option

NumNulls

the percentage of field values to be set to NULL

GenMethod

defines Data generation mode:

0 stands for incremental data generation

1 = random data generation

2 refers to Get data from list / SQL query option

3 = from another field

GenFromSQL

0 = the direct list of values is taken for data generation

1 = SQL query is used

SQL

text of the SQL query from which a list of values is taken for generation (as the result of the SQL query execution)

UsingMask

0 = no mask is used for string field values

1 = generation of string field values by mask

Mask

mask for string field values generation

MinInt

minimal value for integer fields

MaxInt

maximal value for integer fields

UseFormula

0 = no formula

1 = a formula is applied for data generation

Formula

formula for data generation, e.g. x*2+1

Digits

digits quantity for float fields

Precision

precision value for float fields

MinDate

minimum value for date fields

MaxDate

maximum value for date fields

IncludeTime

indicates whether time is added (for DATETIME fields)

MinTime

minimum value for time fields

MaxTime

maximum value for time fields

MinLength

minimum length for string fields

MaxLength

maximum length for string fields

StartChar

first char code for generating strings

EndChar

last char code for generating strings

Charset

field character set

InitialValue

the initial value for data generation into the field

IncrementStep

specifies the step to increment values (for GenMethod = 0)

UseNewLine

1 = a line feed is used for a new line

0 = no line feeds used

WinNewLineStyle

style to be applied to line feeds:

1 = Windows style

0 = Unix style

SampleText

sample text to be generated for a string field