Difference between revisions of "IBID National Database Upgrade"

From EHS Help
Jump to: navigation, search
m
 
(10 intermediate revisions by the same user not shown)
Line 4: Line 4:
  
  
 +
== Procedure ==
  
== Procedure Overview ==
+
# Remove/rename existing cgi-bin\AquilaWeb.exe file to prevent further audit trail uploads from burn services
 
+
# Stop the rebuilder service
# Stop the rebuilder service (''this could be done the night before to allow the overnight backup to secure the database'')
+
 
# Backup the database & verify
 
# Backup the database & verify
# Run the supplied SQL script to update the database & check for zero errors.
+
# Run SQL script to update the database & check for zero errors: '''[http://evolutionhealthcaresystems.co.uk/downloads/doc_details/76-ms-sql-ibid-v39-upgrade-script iBID DBv39 Upgrade SQL Script]'''
# Run the supplied AquilaServer_N.N_upgrade_32-bit_No-recalc.exe file (''where N.N is the version number'')
+
# Run AquilaServer_2.2_upgrade_32-bit_No-recalc.exe file: '''[http://evolutionhealthcaresystems.co.uk/downloads/doc_details/77-aquilaserver-upgrade-to-22-no-recalculations AquilaServer v2.2 Upgrade]'''
# Deploy the supplied AquilaWeb.exe IIS module in place of the existing version  
+
# Deploy the supplied AquilaWeb.exe module: '''[http://evolutionhealthcaresystems.co.uk/downloads/doc_details/78-aquilaweb-22-iis-module AquilaWeb v2.2]'''
# Start the rebuilder service
+
# Restart 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

Latest revision as of 09:02, 3 May 2016


This is a Technical (IT) Instructions topic


Procedure

  1. Remove/rename existing cgi-bin\AquilaWeb.exe file to prevent further audit trail uploads from burn services
  2. Stop the rebuilder service
  3. Backup the database & verify
  4. Run SQL script to update the database & check for zero errors: iBID DBv39 Upgrade SQL Script
  5. Run AquilaServer_2.2_upgrade_32-bit_No-recalc.exe file: AquilaServer v2.2 Upgrade
  6. Deploy the supplied AquilaWeb.exe module: AquilaWeb v2.2
  7. Restart 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