CASE STUDY

Scotland places a high value on clean water, and the quality of its drinking water is robustly enforced. However, the Drinking Water Quality Regulator's (DWQR) aging Oracle system, built in the mid-2000s, was costly to run, slow, and hindered their ability to identify emerging quality and safety trends.

Draining the Drinking Water Quality Regulator's Legacy

The Drinking Water Quality Regulator for Scotland (DWQR) ensure that drinking water in Scotland is safe to drink. 

The DWQR wished to undertake a Discovery exercise to identify the options available for the replacement of their current data management and reporting system so that they could modernise and gain the cost/benefit of adopting Cloud technology. Exception worked in partnership with DWQR to understand their data models, logic and complexity contained within the database. By deploying our legacy cloud migration software tools and expertise, we were able to assess and demonstrate to DWQR the effort, risk and challenges that they would encounter migrating their Oracle datastore from on-premise to a new Cloud service. 

We interrogated their legacy database structure and analysed it against potential target database products. During this process, we also worked closely with DWQR to better understand the data within the current solution, how it is managed and what type of output the business requires. Our detailed analysis allowed DWQR to examine future alternatives and measure the complexity, feasibility and cost of each solution. 

Following the completion of the work, DWQR were able to understand the complexity of their current data store. The work performed also provided an in-depth analysis of the issues, required changes and compatibility with their future cloud database options. 

Our service provides: 

  • A cost-effective discovery of legacy systems providing a better understanding of current systems to enable faster cloud migration 

  • A better technical understanding of legacy software databases to help future procurements helping mitigate risks 

  • Independent analysis to aid your choice of new database options      

“This was an extremely important project from DWQR. Our previous system had been in place for over 15 years and was vital to every aspect of our operations. Exception produced a solution that now handles complex data and reporting in a way that is both user friendly and efficient.”

— OPERATIONS TEAM LEADER - DWQR

Next
Next

Nuclear Restoration Services