Skip to main content
Kofax

How can I import an exported Kofax TotalAgility 7 database to an existing environment?

Summary

11998
  • 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\Transformation Server\Kofax.CEBPM.CPUServer.ServiceHost.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 service - TotalAgility Core Worker and Transformation servers 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: KTA, Import, Export, Database, environment,