Skip to main content

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

Article # 3035190 - Page views: 286


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


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


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


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


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)

Click OK
The server names should now have been updated:


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

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 



Applies to  

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


Article # 3035190
  • Was this article helpful?