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

Summary

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