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

Previous page Moving Intellect configuration database to the latest version of MS SQL Server  Stored procedures for adding or deleting a large number of objects Next page


When INTELLECT™ software is applied by a large-scale system with distributed architecture, servers and Remote Admin Workstations databases should be synced. Database synchronization allows to store data both centrally (on a single server or Remote Admin Workstation) and in a distributed manner (data replication from different servers and Remote Admin Workstation databases of the video surveillance system). Database synchronization provides parallel operation with servers and Remote Admin Workstations databases and their automatic updating after they have been modified.

INTELLECT™ software databases on servers and Remote Admin Workstations are not synced by default. Usually INTELLECT™ software is configured to sync all databases with a single centralized administering server database.

Note.

 If one or more databases are stored in MS Access format, they need to be converted to MS SQL format before the synchronization setup.

The administering Server acts as a synchronization source. The second-level Server/RAW will accept all database changes from the administering Server. Synchronization should always be performed from the second-level Server to the administering Server, or from the RAW to the administering Server.

Important!

You shall install all industry-specific solutions used for the particular distributed system on your Administration Server, otherwise all .ddi and .dbi files as well as the updated database containing these files must be present there.

To sync the INTELLECT™ software “Configuration” database with the administering server database (or any other one), follow the procedure on RAW/second-level Server:

  1. Make sure that MS SQL Server software is.
  2. Start the idb.exe utility from the root of the INTELLECT™ software installation directory (for example, C:\Program Files (x86)\Intellect). The idb.exe utility dialog box will be displayed.
  3. Select the Synchro source item from the Select source database list.
  4. Set the Use checkbox.
  5. Click Build.
  6. The Data link properties dialog box is displayed. Go to the Provider tab in the Data link properties dialog box.
  7. Select Microsoft OLE DB Provider for SQL Server from the OLE DB Provider(s) list.
  8. Click Next.
  9. As soon as the Next button is clicked, there is automatic going to the Connection tab.
  10. In the 1.Select or enter a server name select from the list or input manually the address of MS SQL server containing the database that is to be used as a source to sync with the current database.
  11. The 2.Enter information to log on to the server group is used to enter the type and authentication parameters of the MS SQL server connection. MS SQL server authentication is performed through the user account, authorized in the Windows OS, or by 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 parameters need to be entered, with different authentication techniques for MS SQL server connection:
    1.  If MS SQL server authentication is performed through a user’s Windows OS account, switch to to the Use Windows NT Integrated security position. The user’s current account on the computer, from which the synchronization is performed, should be logged into the computer with MS SQL server and the database to be synced with.
    2. If MS SQL server authentication is performed through user login and password, follow the sequence:
      1. switch to the Use a specific user name and password position;
      2. in the User name field: enter the user name (login) to connect to the MS SQL server.
      3. if access to the MS SQL server is password protected, remove the Blank password checkbox 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.


  12. Click Test Connection.
  13. If the MS SQL server was successfully connected, the “Test connection succeeded” message is displayed.

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


    Click OK to close the window. Then enter the correct password and try MS SQL server connection again.
  15. From the Select the database on the server list choose the name of the database to be synced with the current base.
  16. Click OK in the Data link properties dialog box. The window will close.
  17. Click OK in the right bottom corner of the idb.exe utility window.

Database synchronization setup is completed.

Requirements for TCP/IP Network

  • No labels