Documentation for Intellect 4.11.0-4.11.3. Documentation for other versions of Intellect is available too.

Previous page Using the idb.exe utility  Extracting event protocol into an individual database Next page


It is possible to run idb.exe utility with keys. For this click Start -> Run. Type the path to idb.exe utility and the required key after / in the appeared window.

To display keys, supported by the utility, use the command «idb.exe /?».

idb.exe  utility supports the run with the following keys:

  1. «/update» - the key of running the hidden updating of database (uses intellect.dbi file).
  2. «/sync» - the key of database synchronization with the source of data.
  3. «/backup» - the key of running the process of creation the backup copy of Intellect database. Use the -protocol option to exclude the Event protocol database from the backup (i.e., the full command in this case would be: /backup -protocol).
    The backup copy is created to the address «C:\Users\user\Documents\Intellect». It is used when the idb.exe utility is connected to MS SQL database.
  4. «/restore» - the key of running the database recover from the previously created backup copy. It is used when the idb.exe utility is connected to MS SQL database.
  5. «/set_cs key=value» - the key of saving the connection string to the system registry (summary on parameters of connection to database).
  6. «sql_convert:db_name mssql2000|mssql2005» - the key of running the database conversion process from MS Access to MS SQL format. It is used when the idb.exe utility is connected to MS Access database.

Example. To convert MS Access to MS SQL  database using the key, do the following:

  1. Use the Run command (Start -> Run), specify the key: C:\Program Files\Intellect\idb.exe /sql_convert.
  2. Click the OK button. As a result the dialog box of the idb.exe utility is displayed.
  3. Select MS Access database in the Select data source drop-down list
  4. Click the Convert MS Access to MS SQL database button.
  5. As a result the box suggesting to select MS SQL server is displayed. Click the OK button to continue.
  6. As a result the Data Link Properties box is displayed. In this box you are to:
    1. select the Server name in the drop-down list;
    2. specify the user name and password to log in the Server;
    3. set the Allow saving password checkbox;

    4. go to the All tab;

    5. in the Persist Security Info field, set the True value. This is necessary to correctly save the user password;

    6. click the Test Connection button;
    7. click the OK button to save the changes.
  7. As a result the dialog box suggesting to enter the database name is displayed.
  8. Enter the database name or leave the name suggested  by the system. Click the OK button.
  9. As a result the process of converting MS Access into MS SQL database starts. The progress of the process is displayed in the Protocol table of the idb.exe utility.
  10. When the database is converted, shut down the idb.exe utility (see   Running and shutting-down the utility section).

MS Access database is now converted to the MS SQL format.

  • No labels