Skip to main content
Kofax

How to Migrate Databases to another SQL Server or to SQL Azure

Article # 3035190 - Page views: 30

Article # 3035190 - Page views: 30

Issue

What steps need to be performed in order to migrate Databases to another SQL Server or to SQL Azure?

Solution

When the Kofax TotalAgility databases have been migrated to the new server (SQL Server or SQL Azure),
Use the 'KTAConfigurationUtility' that is shipped with the KTA installation media to point TotalAgility at your new server

Screenshots below are taken from v7.7.0

Run the KTAConfigurationUtility as an administrator
You will be presented with the following window

1.png

Click OK to continue
You will then be asked if you wish to stop the services

2.png

Click Yes
When the services have stopped, 
Click on the ellipsis beside the SQL Server name on any of the databases:

3.png

The Server Setup window will open
Update the SQL Server name and credentials as required
Ensure that the 'Apply these settings to all other Databases' flag is checked
(Alternatively, you can update each database separately)

4.png
Click OK
The server names should now have been updated:

5.png

When you are happy,
Click on the Save button
You will be prompted to restart the services

6.png
Click Yes

The .config files will now have been updated with the new connection strings
Please perform some sanity checks to confirm that everything is working as expected and that all services have been successfully started
Check the Application Event log if you run into any issues

Level of Complexity 

High

 

Applies to  

Product Version Build Environment Hardware
KTA 7.x KTA 7.6 (and above)