Kofax - Database Move

Applies to

Kofax Capture

Summary

Use this procedure to move/configure the Kofax database on a new environment.

Steps

  1. Backup the Kofax database
    1. User will need at minimum the following privileges in SQL to perform a backup.
      1. Server Level:  public
      2. Database Level:  db_backupoperator
  2. Backup the current ACConfig.xml.
    1. Default location is on the Kofax Server.  C:\ProgramData\Kofax\CaptureSV\Config
  3. Restore the Kofax database on the new environment.
    1. User will need at minimum the following privileges in SQL to perform a restore.
      1. Server Level:  DBCREATOR
  4. Modify the ACConfig.zml file.
    1. Modify the database server location.  Use CTRL + F and search for <SqlServerInstance> and modify the server name.
    2. Modify the database name if changed.  Use CTRL + F and search for <Database> and modify the database name.
    3. Leave the password string as is.  (This will be updated when using the DBUTIL.exe application.
    4. Save file after changes and close it.
  5. Open DBUTIL.exe.
    1. Default location is C:\Program Files (x86)\Kofax\CaptureSS\ServLib\Bin for server installs and C:\Program Files (x86)\Kofax\Capture\Bin for workstation installs.
    2. Enter the server name, database name, deselect "Create New Database", and enter SQL Credentials. Dbutil.exe will encrypt and overwrite the password in the ACConfig.xml file.
    3. Apply the changes and close Dbutil.exe.

CASO Knowledge Base