Go to documentation repository
Documentation for Intellect 4.11.0-4.11.3. Documentation for other versions of Intellect is available too.
Previous page Next page
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 | 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. | 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:
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 | 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 | Clear protocols | 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. | No | 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. |
Overview
Content Tools