Skip to main content
Kofax

How to restore a KTA database to another SQL database server

Article # 3034886 - Page views: 60

Issue

What items are changed, and what steps need to be taken so that I can restore KTA Databases to another SQL Server?

Solution

After restoring backups of all KTA Databases to another, the KTA Configuration Utility should be used to update the connection strings used by KTA.
This utility will prompt you to shut down all nessessary services, it will then allow for the DB Server/DB Names to be changed for each KTA DB.
After saving the changes, the utility will ask if you wish to restart the services.

The Configuration Utility has been available since KTA 7.4, and it will automatically update any connection strings referenced in the KTA DB or used in the KTA .config files.

 

For instructions on how to do this in legacy versions of KTA (KTA 7.3 and earlier), this can be achieved by performing the following:

 

  • 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,

 

Level of Complexity 

High

 

Applies to  

Product Version Build Environment Hardware
Kofax TotalAgility 7.x      

References

Add any references to other internal or external articles

 

Article # 3034886