Overview
Background
This project was originally going to be a two phase approach.
- Phase 1 to deliver short-term upgrade to infrastructure
- Phase 2 to evaluate and implement move to new Web version of ThankQ.
Phase 2 has been taken out of scope for this project as Development and Alumni are going to procurement to replace ThankQ and this process could take 9 to 12 months. This work is done under USG014 Development and Alumni CRM Procurement. Following this, the implementation of the chosen product would be completed within the 24 month period.
This project will focus on providing end of life infrastructure upgrades to allow ThankQ to run on a supported environment until procurement of the new software takes place.
Scope
ThankQ is running on the following:
|
|
App Tech/Version |
Web Server/Version |
App OS/Version |
DB/Version
|
DB OS/Version |
|
Technology |
ASP/.Net 2.0.50727 |
IIS 7.5 |
Windows Server 2008 R2 |
SQL Server 2008 |
Windows 2008 R2 |
|
End of Life Date |
12 Jul 2007 |
13 Jan 2015 14 Jan 2020 (extended) |
13 Jan 2015 14 Jan 2020 (extended) |
8 Jul 2014 9 Jul 2019 (extended) |
13 Jan 2015 14 Jan 2020 (extended) |
An analysis phase has been completed in order to determine the specification of the infrastructure required for the database and application servers that the existing version on the ThankQ application is supported and will run on.There is only a TEST, TRN and LIVE server, with TRN and LIVE on the same virtual server as is currently set up.
UoE will
- Provide the virtual application and database servers, built and configured to the specification supported in the supplied documentation.
- Support the Access Group in their installation of the application to the new servers and in the migration of the data to the new database.
Development and Alumni have agreed with the Access Group that the Access Group will:
- Install ThankQ application on new server environments
- Complete the database migration and ThankQ application repointed to new database on TEST
- Complete the database migration and ThankQ application repointed to new database on LIVE
Objectives and Deliverables
| Number | Description |
Priority Moscow |
| Objective 1 |
To ensure that the application server components are upgraded to versions that will remain supported until the end of the procurement period (24 months), or to the latest version that is supported by ThankQ |
|
| D1.1 |
Provide a new virtual machine for the application with the following specification: Specification as per the "thankQ_hardwareandsoftwarerequirements_2018" document. Running on Windows Server 2016. This will in turn upgrade the following:
|
Must Have |
|
D1.2 |
Our current version of the ThankQ application installed and configured by The Access Group. |
Must Have |
| D1.3 | Upgrade the MyEd Alumni portal channels. | Must Have |
| Objective 2 | To ensure that the ThankQ is running on a supported database and operating system | |
| D2.1 |
Provide a new virtual machine for the database Specification as per the "thankQ_hardwareandsoftwarerequirements_2018" document. Operating system: Windows Server 2016 Database: SQL Server 2016 Standard Edition |
Must Have |
| D2.2 |
Access Group to perform database migration & ThankQ app repointing from current SQL 2008 database |
Must Have |
| Objective 3 | To ensure that old versions of software and infrastructure are decommissioned | |
| D2.2 | Decommission legacy infrastructure and components on both database and application tier if they are unused | Must Have |
Benefits
- ThankQ will run on supported application and database infrastructure until its replacement is implemented.
Success Criteria
- The upgrade of the application tier is completed successfully with any post upgrade issues resolved
- The database migration is completed successfully and is running on supported infrastructure
Project Milestones
| Planning sign off | 28-Jun-2019 |
| Infrastructure set up complete | 12-Jul-2019 |
| Acceptance Sign Off | 23-Aug-2019 |
| Deploy to LIVE | 28-Aug-2019 |
| Deployment Sign Off Review | 16-Sep-2019 |
| Closure | 23-Sep-2019 |