Interface elements of the idb.exe window

1

Select source database

A drop-down list for selecting the database: local, events log, or remote.

Basic data

Basic data – local configuration database

Synchro source – remote database for synchronization

Protocol – events log database

Other values are used with vertical solutions.

2

Description

An information field showing the description of the selected source database.

Base for a configuration system Intellect

Base for a configuration system Intellect – Main configuration database of the Intellect system

Remote database for synchronization

Events log database

Other values are not used.

3

Use

A checkbox for enabling/disabling database usage. When checked, the Build button becomes enabled which is used for setting up the connection to the database.

Checked

Checked – database connected

Unchecked – database not connected

4

Move database

A button for starting the process of creating an .mdf file in MS SQL format to be transferred to another MS SQL server later.

Enabled

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

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

5

Build

A button for opening the Data Link Properties dialog box for database connection setup. This button is enabled if the Use checkbox is checked.

Enabled

Enabled – idb.exe utility is connected to the database

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

6

Connection string

An information field showing the summary about the database connection

Depends on database connection parameters and server/workstation configuration

Shows the following parameters:

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

The Provider parameter can take the following values:

SQLOLEDB.1 – MS SQL database

Microsoft.Jet.OLEDB.4.0 – MS Access 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 login/password, or MS Access database is used.

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 an MS SQL server used for controlling the database;

full pathname of the .mdb file of an MS Access 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

12

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

13

Create dbi-file

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

Enabled

Enabled - .dbi file creation is allowed.

14

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.

15

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.