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:
- Perform an
iisreset
via a Command Prompt. - Delete the cache of the browser. (ctrl – shift – delete, select all excluding passwords and preserve favorite website data)
- Restart the service - TotalAgility Core Worker and Transformation servers services
- Log onto KTA Designer, enter new license location details
- May need to deactivate/update in KTA designer any existing KIC imports
- Ensure KTA designer and KTA workspace are accessible.
Keywords: KTA, Import, Export, Database, environment,