Go to documentation repository
Documentation for Intellect 4.11.0-4.11.3. Documentation for other versions of Intellect is available too.
The figure below shows the idb.exe dialog box.
The table describes the interface elements of the idb.exe utility dialog box.
№ | Element name | Description | Default value | Allowed values |
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:
Other values are not used. The Integrated Security parameter can take the following values:
The Persist Security Info parameter can take the following values:
The Data Source parameter can take the following values:
|
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 |
11 | The Clear protocols checkbox | 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 | No | 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 |