Chaos ? Nah, just more money spent
This is going to be both an administrative and tech disaster.
It also feels rather than streamlining things, it'll give greater control to fewer, with less accountability.
Databases are relatively easy to build. It's the database reporting that generally bloats it.
Boss Z wants it their way. Director W theirs, Manager Y her's, and the I.T team are stressed out because everyone is saying different things, yet the people that need to use said database daily, are rarely consulted. Yet they are the ones having to waste time inputting on foul flow charts and migrated systems with clanky interfaces.
With the recent AWS outage as an example of eggs in one basket, does anyone else see a potential tech titanic heading towards a data iceberg with all these councils and local authorities being culled and forced into a new entity ?
One thing, if we as a sector came up with a best practices framework, so that users were the primary consulted parties, not the occasional users, would that help us provide a much better system, and one that might last 20 years plus, as some of the legacy systems have exceeded ?
I cite one hospital trust that had a rock solid, green screen, terminal system
The reason it was replaced, it was awful at exporting any data, but just kept working.
Anyone over 40 will likely have similar experiences, with perfectly good software being replaced for worse ones, purely because of the new reporting and analysis demands.