Understanding the problem
In late 2018 WorkingMouse and Codebots qualified as finalists in the NSW Pitch to Pilot program. As part of the program we were able to pitch the Codebots firecracker migration method via the Codebots platform and Continuous Modernisation Playbook to several senior NSW IT leaders. Following the event, WorkingMouse was contacted by NSW Police Force and given the opportunity to pilot Codebots within the organisation. The project comprised of beginning to modernise their 200 plus legacy Access databases that sit within their operational division.
Ideation & research
To begin, we ran a proof of concept that focused on modernising 7 Fatal Crash Microsoft Access Databases. The offline system is used by the traffic research and intelligence unit as part of their traffic & highway patrol command. There were three key issues the team aimed to tackle. 1. The information was stored on outdated Microsoft Access Databases which is not in line with the Department's modern web-based skill set. 2. The support required from the internal IT department was significant due to the databases breaking and the constant reloading of backups. 3. The time it would take for the safety team to copy the data over from the COPS system on a daily basis.