Skip to main content

TotalAgility Database Upgrade Screens Reference

Article # 3031578 - Page views: 171


This shows the screens that are presented when running the KTA database upgrade.  These example screens are from KTA 7.9 and show upgrading from KTA 7.5.  While upgrades involving other versions may have some differences in the install screens, this can still act as a general reference to the steps and the options available in the upgrade process.

Some noteworthy aspects are shown here:

  • The Capture Data Migration process occurs when upgrading from KTA 7.7 or lower to KTA 7.8 or higher.
  • The check for updates to the Capture Data Migration process occurs when upgrading from KTA 7.7 or lower to KTA 7.8 R2 or higher.

See also:

TotalAgility Install Screens Reference

TotalAgility Integration Server Install Screens Reference



Check For Updates

This check was added in KTA 7.8 R2 and KTA 7.9.  It does not exist in the initial release of KTA 7.8.


When clicking No, the installer continues on to the Credentials screen.

When clicking Yes, the installer concludes at the prompt to Download Migration Updates.


Download Migration Updates

If Yes was clicked on the check for updates message box, the installation review screen shows the URL ( to download updates.



Capture Migration Updates Tool

After downloading the update, run [Install Source]\TotalAgility\TotalAgilityInstall\Agility.Install.ApplyCaptureMigrationUpdates.exe, browse to the downloaded zip file, and click OK.  After this updates the install files, start the installation again.



After clicking No at Check For Updates, the Credentials screen appears.


Installation Review


Installation Progress

Even for a database-only upgrade, files are copied locally from which to run the scripts and database artifact upgrade process.  This step will also include running the database scripts that upgrade the database schema.  The scripts can be found in the install source at \TotalAgility\TotalAgilityInstall\DatabaseScripts\SQL Server\Upgrade Database Scripts\.


Capture Data Migration Precheck

At this point KTA 7.8 R2 and KTA 7.9+ will run the precheck script from [Install Source]\TotalAgility\TotalAgilityInstall\DatabaseScripts\SQL Server\DataLayer\MigrationPreCheck.sql.  If any problem results are found, then the following error will popup.


Capture Data Migration

The time it takes to migrate capture data is based on the size of the TotalAgility_Documents database, and the performance of the SQL Server.


Database Artifacts Upgrade

After Capture Data Migration, database artifacts will be upgraded.  Agility.Installation.Server.Upgrade.exe is run to upgrade data that needs to be updated by code rather than SQL scripts.

Installation Complete




  • Was this article helpful?