Go to documentation repository
Page History
...
- «/update» - the key of running the hidden updating of database (uses intellect.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 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«C:\Documents and SettingsUsers\USER2user\My documentsDocuments\AxxonSoft\Intellect\Data\intellect.sql.bak»Intellect». 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.
...
- Use the Run command (Start -> Run), specify the key: C:\Program Files\Intellect\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 dropdown 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.
- As a result the Data Link Properties box is displayed. Un this box you are to:
- select the Server name in the dropdown list;
- specify the user name and password to log in the Server;
- set the Allow saving password checkbox checked;
- click the Test Connection button;
- click the OK button to save the changes.
- As a result the dialog box suggesting to enter the database name is displayed.
- 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).
MS Access database is now converted to the MS SQL format.
Overview
Content Tools