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.
...
- «/update» − the key of running the hidden updating of database (uses psim.dbi file).
- «/sync» − the key of database synchronization with the source of data.
- «/backup» − the key of running the process of creation the backup copy of Axxon PSIM 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\Axxon PSIM». It is used when the idb.exe utility is connected to MS SQL database. - «/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.
- «/set_cs key=value» − the key of saving the connection string to the system registry (summary on parameters of connection to database).
- «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.
...
- to
...
- database
...
- Use the Run command (Start -> Run), specify the key: C:\Program Files\Axxon PSIM\idb.exe /sql_convert.
- Click the OK button. As a result the dialog box of the idb.exe utility is displayed.
- Select MS Access database in the Select data source drop-down list.
- Click the Convert MS Access to MS SQL database button.
- As a result the box suggesting to select MS SQL server is displayed. Click the OK button to continue.
Image Removed - As a result the Data Link Properties box is displayed. In this box you are to:
- select the Server name in the drop-down list;
- specify the user name and password to log in the Server;
- set the Allow saving password checkbox;
go to the All tab;
in the Persist Security Info field, set the True value. This is necessary to correctly save the user password;
- click the Test Connection button;
- click the OK button to save the changes.
Image Removed
- As a result the dialog box suggesting to enter the database name is displayed.
Image Removed - Enter the database name or leave the name suggested by the system. Click the OK button.
- 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.
- When the database is converted, shut down the idb.exe utility (see Running and shutting-down the utility section).
...
- .