Page History

1

The Select data source

drop-down list

The drop-down list for selecting the database: local

Configuration database, Event protocol database, or a remote

database for synchronization

Basic data

Basic data – local

Configuration database

Synchro source – remote database for synchronization

Protocol

– Event protocol database

Titles – Captions database

Other values are used when working with vertical solutions

2

The Description field

The 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

Synchro source – remote database for synchronization

"Intellect" system's external protocols database –Event protocol database

Titles database – Captions database

Other values depend on the availability of the databases for the installed vertical solutions.

3

The Use checkbox

The 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

source data source), files can not be moved

Active

Active – 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 workstation configuration 

Displays 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

Information field and the Select

dbi-file button

The information field and

the button for selecting and displaying

the database structure

.dbi

file. The updated database will have the structure specified in this file

C:\Program Files\Intellect\intellect.dbi

The full path to the .dbi file

8

Information field and the Select dbi-file button

The

information field and

the button for selecting and displaying the

information about the .ddi file with system objects, events and

reactions

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

The full path to the .

dbi file

9

The Create backup copy (MS SQL) button

The button for starting the process of creating a backup copy of the database. This button is

active if the idb.exe utility is connected to

the MS SQL format database

Active

Active – 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

10

The Restore from backup (MS SQL) button

The button for restoring the database from a previously created backup

Active

Active – 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

The checkbox

that excludes the Event

log database

from the created database backup copy.It is recommended to set this checkbox if the size of the Event

log database is too large, and there is no need to include the Event

log in

the backup copy.

The setting is available only for

Intellect base database

Checked – the database backup copy does not include the Event

log database

Clear – the database backup copy includes the Event

log database

12

The Update database button

The 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

Active

Active – the idb.exe utility is connected to the

Configuration database

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

Configuration database

13

The Create dbi-file button

The button for creating a database structure .dbi file (

template)

Active

Active – .dbi file creation is allowed

14

The Protocol information table

The information table that displays the progress of database processing: converting, structure updating, creating backup copy, etc.

Empty

Information messages about the progress of the database processing.

The blue “i”

icon indicates that the processing step has been successfully completed

The

red “!”

icon indicates the errors in

the processing step

A blue tick

icon indicates the completion of the processing

15

The OK button

The button for saving the database connection parameters and shutting

down the idb.exe utility

Active

Active – saving database connection parameters and shutting

down the idb.exe utility is allowed

Inactive – the utility is still processing the database