Difference between revisions of "IBID National Database Upgrade"

From EHS Help
Jump to: navigation, search
Line 7: Line 7:
 
== Procedure Overview ==
 
== Procedure Overview ==
  
# Stop the rebuilder service (''this could be done the night before to allow the overnight backup to secure the database'')
+
# Stop the rebuilder service
 
# Backup the database & verify
 
# Backup the database & verify
 
# Run the supplied SQL script to update the database & check for zero errors.
 
# Run the supplied SQL script to update the database & check for zero errors.
Line 13: Line 13:
 
# Deploy the supplied AquilaWeb.exe IIS module in place of the existing version  
 
# Deploy the supplied AquilaWeb.exe IIS module in place of the existing version  
 
# Start the rebuilder service
 
# Start the rebuilder service
 +
 +
 +
== Recovery on Upgrade Failure ==
 +
 +
At any point should the upgrade fail the recovery procedure is:
 +
 +
# Restore the database from the backup
 +
# Uninstall any version of AquilaServer & install the previous version of AquilaServer (available from EHS)
 +
# Remove the latest version of AquilaWeb & replace with previous version (available from EHS)
 +
# start the rebuilder & re-schedule

Revision as of 15:28, 28 April 2016


This is a Technical (IT) Instructions topic


Procedure Overview

  1. Stop the rebuilder service
  2. Backup the database & verify
  3. Run the supplied SQL script to update the database & check for zero errors.
  4. Run the supplied AquilaServer_N.N_upgrade_32-bit_No-recalc.exe file (where N.N is the version number)
  5. Deploy the supplied AquilaWeb.exe IIS module in place of the existing version
  6. Start the rebuilder service


Recovery on Upgrade Failure

At any point should the upgrade fail the recovery procedure is:

  1. Restore the database from the backup
  2. Uninstall any version of AquilaServer & install the previous version of AquilaServer (available from EHS)
  3. Remove the latest version of AquilaWeb & replace with previous version (available from EHS)
  4. start the rebuilder & re-schedule