Difference between revisions of "IBID National Database Upgrade"

From EHS Help
Jump to: navigation, search
(added URLs to files)
(added first step about removing AquilaWeb before starting)
Line 6: Line 6:
 
== Procedure ==
 
== Procedure ==
  
 +
# Remove/rename existing cgi-bin\AquilaWeb.exe file to prevent further audit trail uploads
 
# Stop the rebuilder service
 
# Stop the rebuilder service
 
# Backup the database & verify
 
# Backup the database & verify
Line 12: Line 13:
 
# Run the supplied AquilaServer_N.N_upgrade_32-bit_No-recalc.exe file (''where N.N is the version number''):
 
# Run the supplied AquilaServer_N.N_upgrade_32-bit_No-recalc.exe file (''where N.N is the version number''):
 
## [http://evolutionhealthcaresystems.co.uk/downloads/doc_details/77-aquilaserver-upgrade-to-22-no-recalculations http://evolutionhealthcaresystems.co.uk/downloads/doc_details/77-aquilaserver-upgrade-to-22-no-recalculations]
 
## [http://evolutionhealthcaresystems.co.uk/downloads/doc_details/77-aquilaserver-upgrade-to-22-no-recalculations http://evolutionhealthcaresystems.co.uk/downloads/doc_details/77-aquilaserver-upgrade-to-22-no-recalculations]
# 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 http://evolutionhealthcaresystems.co.uk/downloads/doc_details/78-aquilaweb-22-iis-module]
 
## [http://evolutionhealthcaresystems.co.uk/downloads/doc_details/78-aquilaweb-22-iis-module http://evolutionhealthcaresystems.co.uk/downloads/doc_details/78-aquilaweb-22-iis-module]
 
# Start the rebuilder service
 
# Start the rebuilder service

Revision as of 08:52, 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
  2. Stop the rebuilder service
  3. Backup the database & verify
  4. Run the supplied SQL script to update the database & check for zero errors:
    1. http://evolutionhealthcaresystems.co.uk/downloads/doc_details/76-ms-sql-ibid-v39-upgrade-script
  5. Run the supplied AquilaServer_N.N_upgrade_32-bit_No-recalc.exe file (where N.N is the version number):
    1. http://evolutionhealthcaresystems.co.uk/downloads/doc_details/77-aquilaserver-upgrade-to-22-no-recalculations
  6. Deploy the supplied AquilaWeb.exe module:
    1. http://evolutionhealthcaresystems.co.uk/downloads/doc_details/78-aquilaweb-22-iis-module
  7. 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