Page History

1

Select data source

A drop-down list for selecting the database: local Configuration database,

Events log database, or a remote

database for synchronization

Basic data

Basic data – local

Configuration database

Synchro source – remote database for synchronization

Protocol –

Events log database

Other values are used when working with vertical solutions

2

Description

Information field

that displays the description of the selected

data source from the Select data source drop-down list

Intellect main database

"Intellect" main database – local Configuration database

Remote database for synchronization

Events log database

Other values are not used

3

Use

A checkbox for enabling

or disabling the selected database usage. When

set, the

Configure button becomes

active, which is used for setting up the connection to the database

Checked

Checked – database is connected

Clear – database is not connected

4

The Move database button

The button used to transfer MS SQL Server database files (.mdf and .ldf) to the specified folder. The user

should have the rights to create files in this folder. When the files are moved, the database is automatically attached.
Note. It is possible to

move only the local DB (Basic data data source). When using a remote DB (Synchro sourse data source), files can not be moved.

Active

Acttive – the idb.exe utility is connected to

the MS SQL format database

Inactive – the idb.exe utility is not connected to

the MS SQL format database

5

The Configure button

The button

opens the Data Link Properties dialog box

to configure the database connection

. This button is

active if the Use checkbox is

set.

Active

Active – the idb.exe utility is connected to the database

Inactive – the idb.exe utility is not connected to the database

6

The Connection string information field

The information field

displaying the summary about the database connection parameters

Depends on the database connection parameters

, the server

configuration or Remote Administrator's workplace configuration 

Shows the combination of the following parameters:

Provider, Integrated Security, Persist Security Info, Data Source.

The Provider parameter can take the following values:

• SQLOLEDB.1 – when using the MS SQL server format database;
• Microsoft.Jet.OLEDB.4.0 – when using the MS Access format server database

Other values are not used.

The Integrated Security parameter can take the following values:

• SSPI – authentication on MS SQL server using Windows account information;
• parameter not shown – authentication on MS SQL server using the user login/password, or using MS Access format database

The Persist Security Info parameter can take the following values:

• True – allow saving the password for automatic connection to the database;
• False – do not allow saving the password for automatic connection to the database

The Data Source parameter can take the following values:

• the name of

• the MS SQL server used for

• managing the database;

• the path to the .mdb file of

• the MS Access format database

7

Select .dbi file

An information field and a button for selecting and displaying a database structure file (.dbi). The updated database will have the structure specified in this file.

C:\Program Files\Intellect\intellect.dbi

Full pathname of the .dbi file

8

Select .ddi file

An information field and a button for selecting and displaying the name of the .ddi file with system objects, events and actions.

C:\Program Files\Intellect\Languages\ru\intellect.ddi

Full pathname of the .ddi file

9

Convert MS Access to MS SQL database

A button for starting the conversion of an MS Access database to MS SQL format. This button is enabled if the utility is connected to an MS Access database.

Disabled

Enabled – idb.exe utility is connected to an MS SQL database

Disabled – idb.exe utility is not connected to an MS Access database

10

Create backup copy (MS SQL)

A button for starting the process of creating a backup copy of the database. This button is enabled if the utility is connected to an MS SQL database.

Enabled

Enabled – idb.exe utility is connected to an MS SQL database

Disabled – idb.exe utility is not connected to an MS SQL database

11

Restore from backup (MS SQL)

A button for restoring the database from a backup.

Enabled

Enabled – idb.exe utility is connected to an MS SQL database

Disabled – idb.exe utility is not connected to an MS SQL database

A checkbox excluding the Event protocol database while creating the database backup copy. It is recommended to set this checkbox if the size of the Event protocol database is too large, and there is no need to include the Event protocol in a backup copy.

The setting is available only for the Intellect base database.

Yes – the database backup does not include the Event protocol database.

No – the database backup includes the Event protocol database.

13

Update database

A button for starting the process of updating the database structure. The structure is updated according to the .dbi file specified in the Select .dbi File field.

Enabled

Enabled – idb.exe utility is connected to the configuration database

Disabled – idb.exe utility is not connected to the configuration database

14

Create dbi-file

A button for creating a database structure file (.dbi template).

Enabled

Enabled - .dbi file creation is allowed.

15

Protocol

An information area displaying the progress of database processing: converting, structure updating, creating backup copy, etc.

Empty

An information area displaying the progress of the database processing.

A blue “i” marks the notifications about successful completion of each processing step.

A red “!” marks the notifications about the errors in a processing step.

A blue tick marks the completion of the processing.

16

OK

A button for saving the database connection parameters and shutting-down the idb.exe utility.

Enabled

Enabled – saving database connection parameters and shutting-down the utility is allowed.

Disabled – the utility is still processing the database.