Skip to main content
Kofax

Kofax TotalAgility 7.2 - How to restore a KTA database to another SQL database server

Summary

13261
  • Restore TA and documents database into SQL management studio.
  • Update KTA and TS connection strings:
    • C:\Program Files\Kofax\TotalAgility\Agility.Server.Web\web.config
    • C:\Program Files\Kofax\TotalAgility\CoreWorkerService\Agility.Server.Core.WorkerService.exe.config
    • C:\Program Files\Kofax\TotalAgility\CoreWorkerService\Agility.Server.Core.ExportService.exe.config
    • C:\Program Files\Kofax\TotalAgility\CoreWorkerService\Agility.Server.StreamingService.exe.config
    • C:\Program Files\Kofax\TotalAgility\Transformation Server\Kofax.CEBPM.CPUServer.ServiceHost.exe.config
    • C:\Program Files(x86)\Kofax\TotalAgility\Reporting\Kofax.CEBPM.Reporting.TAService.exe.config

      eg
<add key="MainDBConnectionString"
value="Server=NEWINSTANCE;Trusted_Connection=Yes;Database=TotalAgility;" />
<add key="ArchiveDBConnectionString"
value="Server=NEWINSTANCE;Trusted_Connection=Yes;Database=TotalAgility;" />
<add key="AuditDBConnectionString"
value="Server=NEWINSTANCE;Trusted_Connection=Yes;Database=TotalAgility;" />
  • Update the KTA server data table CEBPM_SETTINGS column with the new documents database connection string
UPDATE server_data SET CEBPM_SETTINGS = REPLACE(CAST(CEBPM_SETTINGS as varchar(max)), 
'OLDCONNECTIONSTRING', 'NEWCONNECTIONSTRING')

eg

UPDATE server_data SET CEBPM_SETTINGS = REPLACE(CAST(CEBPM_SETTINGS as varchar(max)), 'Data
Source=W2K8-SQL2012;Initial Catalog=TotalAgility_Documents;User ID=;Password=;Integrated
Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False', 'Data
Source=NEWINSTANCE;Initial Catalog=TotalAgility_Documents;User ID=;Password=;Integrated
Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False')

Update the KTA NT_RESOURCE table with your user:

UPDATE nt_resource SET nt_name = REPLACE(nt_name, 'domain\oldResource', 'domain\NewResource')

UPDATE nt_resource SET nt_name = REPLACE(nt_name, 'domain\oldresource', 'domain\newresource’)

Afterwards, perform following steps to finish the import process:

  1. Perform an iisreset via a Command Prompt.
  2. Delete the cache of the browser. (ctrl – shift – delete, select all excluding passwords and preserve favorite website data)
  3. Restart the Kofax TotalAgility services
  4. Log onto KTA Designer, enter new license location details
  5. May need to deactivate/update in KTA designer any existing KIC imports
  6. Ensure KTA designer and KTA workspace are accessible.

Keywords: SQL Server, Database Restore,