Converting the database from MS Access to MS SQL format

Intellect™ software version 4.10.0 is default configured to operate with the database MS SQL server format. MS Access format databases have been used in previous Intellect™ software versions. If the system needs configuration parameters, stored in MS Access format after INTELLECT™ software has been updated to version 4.10.0, it is strongly recommended to convert the database into MS SQL server format.

To convert the database from MS Access to MS SQL server format, follow the steps:

Set up MS SQL server software, if it has not been set up before.
Make sure that the MS SQL server software is on.
Launch the idb.exe utility in the root of the INTELLECT™ software installation directory (for example, C:\Program Files (x86)\Intellect). The idb.exe utility dialog box is displayed.
Choose the Basic data item from the Select data source list.
Check the Use checkbox, if not checked before.
Click Build.
The Data link properties dialog box is displayed. Go to the Provider tab in the Data link properties dialog box.
Select Microsoft Jet 4.0 OLE DB Provider from the OLE DB Providers list.
Click Next.
As soon as Next is clicked, the dialog box automatically takes you to Connection tab.
Type the complete path to the database file in the 1. Select or enter a database name or select the necessary file from the file opening dialog box, which is displayed by the … button.
Enter the user name (login) for database access in the User field. If database access is not protected, leave the field empty.
If access to the database is protected, remove the default Blank password check and enter the database access password into the Password field.
Click Test Connection.
If MS Access database connection was completed, the Test connection succeeded message is displayed.

Click OK to close the window.
If the MS Access database name and/or authentication parameters of database connection were entered incorrectly, the relevant error message will pop up.

Click OK to close the window. Then enter the correct password and try the MS SQL server connection again.
Click OK in the Data link properties dialog box. The window closes.
Update the database structure. To do that click the Convert MS Access to MS SQL button in the idb.exe utility dialog box.
The Select MS SQL server message appears.

Click OK to close the window.
The Data link properties dialog box is displayed. In the 1.Select or enter a server name select from the list or type the name of the MS SQL server, which will be used to convert the database.
The Enter information to log on to the server box is checked to enter the type and authentication parameters of MS SQL server connection. MS SQL server authentication is performed through the user account, authorized in Windows OS, or the user name (login) and password, that protect the MS SQL server connection.
The method and parameters of authentication at the MS SQL server are set during MS SQL server installation.
Different settings need to be entered, with different authentication techniques for MS SQL server connection:
1. If MS SQL server authentication is performed through the user account in Windows OS, switch to the Windows NT account box and check it.
  Note.
  If converting is performed via remote MS SQL server, it is necessary to log in computer with MS SQL server the user’s current account from computer that performs the conversion.
2. If MS SQL server authentication is performed through the user login and password, follow the sequence:
  1. switch to to the Next user name and password position.
  2. in the User field: enter the user name (login) to connect MS SQL server.
  3. if access to the MS SQL server is password protected, remove the default Blank password check and enter the database access password into the Password field.
  4. Set the Allow saving password checkbox.
  5. Go to the All tab.
  6. In the Persist Security Info field, set the True value. This is necessary to correctly save the user password.
    Note
    Each time you change the server connection parameters, you must set the Persist Security Info field value to True.
Click Test Connection.
If MS SQL server connection was completed, the Test connection succeeded message is displayed.

Click OK to close the window.
If the MS SQL server name and/or authentication parameters of the MS SQL server connection were misentered, the relevant message will appear.

Click OK to close the window. Then enter the correct password and try MS SQL server connection again.
Click OK in the Data link properties dialog box.
The Enter database name message will appear.

Enter the name to be used for database storage on the MS SQL server in the top field. It is default recommended to use INTELLECT as the database name.
Note.
If the MS SQL server has a database with the same name, as has been entered in the Enter the database name field, it will be overwritten.

Confirm the entry of the database name by clicking OK and close the window.
Then the database conversion process starts from MS Access to the MS SQL server format, and the relevant steps appear in the Protocol table in the idb.exe utility dialog box.
After the database conversion process is completed the request message appears: "Reset current connection to MS SQL?".

Click the Yes button, if you want to set up INTELLECT™ software to operate with a MS SQL server format database, converted from MS Access format. Otherwise click No.
When the conversion process is successfully completed, the Completed! step appears in the Protocol table in the idb.exe utility window.
Click OK in the bottom right corner of the idb.exe utility window.

Converting the database from MS Access to MS SQL format is completed.

Page tree

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