Welcome > The Kofax Search and Matching Server Administration > Set Up Load Balancing > Update the Database

Update the Database

The update from the database must be performed separately for each Kofax Search and Matching Server node. The process imports a zip file that needs to be created on a different Kofax Search and Matching Server server and then exported as a zip file using the full export mode. This zip file must be created on a Kofax Search and Matching Server server that is not part of the cluster running in restricted mode.

Note You do not need to stop the Kofax Search and Matching Server node service, nor do you need to remove it from the Load Balancer in order to import a database. The previous database is available and still used while the database is updated. At the end of the import the new database becomes active and is used for all future searches.

The update is done via the Command line tool and the user calling the Kofax.KSMS.Administration.exe tool must be a member of the "KSMS Administrators" group created during installation. If the user is not part of this user group, they do not have the necessary permissions to perform this action.

Important It is necessary to update every database after the server is configured for "restricted mode", even if that database is configured for automatic updates. If a database is not updated, it will be ignored by the node and any queries to that database are skipped.

You can update a database by following these steps:

  1. Open the Command Prompt.
  2. Run one of the following commands:

    • Kofax.KSMS.Administration.exe /i NodeAddress="localhost" NodePort="22000" ZipPath="C:\zip\KSMSExportDatabases.zip" ZipFilePassword="PasswordIfAnyUsedOtherwiseBlank" DatabaseName="Database"

      This string updates the specified database using a zip file that was created on another node.

    • start wait/ Kofax.KSMS.Administration.exe /i NodeAddress="localhost" NodePort="22000" ZipPath="C:\zip\KSMSExportDatabases.zip" ZipFilePassword="PasswordIfAnyUsedOtherwiseBlank" DatabaseName="Database"

      This string also updates the specified database using a zip file that was created on another node.

      In addition to the first string, this enables users to type in the echo %ERRORLEVEL% command to see whether the update command was successful or not.

      A value of 0 indicates a successful update. A value of 1 indicates an error with the update.

    Tip To suppress error message windows that might be displayed during an update, use the /q parameter.
    After import, the database is set to "Active" automatically.