The Situation
The Pyrite application had been set up by the Housing Agency as part of the Pyrite Remediation Scheme - to provide an online application appeals process for citizens whose dwellings had been significantly damaged as a result of pyritic heave caused by the swelling of hardcore underground floor slabs.
The application had historically been hosted by the LGMA (Local Government Management Agency), however a new hosting environment was required.
Consequently, the Housing Agency needed to consider the migration of system data to SQL Server 2016 since the application had been running on a combination of Microsoft Windows and SQL Server versions 2008, the support of which was ending in January 2020.
This was a crucial factor in the decision to upgrade the system to mitigate the risks associated with hosting a business-critical application on legacy software.
A Dual Interface Application, balancing user-friendliness and system security.
The application, built with robust features, consisted of two primary components; (i) a user-friendly web application interface designed to ensure ease of use, and (ii) a high-performance SQL backend database that promises efficiency and reliability. To cater to different user groups, it was imperative to set up two separate instances of the web interface. The public website serves general users with essential information, while the administrative site, equipped with advanced security features, is exclusively for system administrators, providing them the necessary oversight tools.
Given the inherent risks in migration projects, especially with numerous integrations to other systems, collaboration between OpenSky and the Housing Agency was crucial to ensure timely and successful project delivery. To minimise disruption to business operations and service delivery, downtime was kept to the bare minimum by strategically scheduling testing outside of regular business hours.
Key Features
- New Servers with Up to Date MS Windows & SQL Server
- Fully Managed Hosting Services by OpenSky
- Data Migrated to a Fully Supported & Compliant Software Configuration
