Most migration problems begin long before any data is moved. 

They begin with unclear ownership. 

When councils merge, there are often: 

• competing priorities 
• overlapping leadership structures  
• different operational cultures  
• multiple opinions on “how things should work”  

Without strong governance, migration quickly becomes fragmented. 

Councils need: 

• clear executive sponsorship  
• decision-making authority  
• cross-authority steering groups  
• risk ownership  
• agreed escalation routes  

Technology should support the organisational vision, not define it. 

Because if governance is unclear, every technology decision becomes slower, harder and more political.

This sounds obvious. 

It isn’t. 

Most councils genuinely do not know the full extent of: 

• their databases  
• document repositories  
• SharePoint estates  
• legacy applications  
• duplicated systems  
• disconnected spreadsheets  

Years of departmental growth, policy change and operational workarounds often create enormous hidden complexity. 

One council might store housing information in Dynamics 365. 

Another may still rely on historic SQL databases. 

Another may have critical operational knowledge sitting in unmanaged SharePoint folders called: 

“Final_Version_v2_ActuallyFinal” 

Before migration begins, councils need a proper discovery exercise. 

Not just: 

“What systems do we use?” 

But: 

• What data matters?  
• What is duplicated?  
• What is still operationally required?  
• What can be archived?  
• What introduces risk?  

Bad migration usually starts with bad visibility.

One of the biggest mistakes authorities make is assuming everything must move. 

It doesn’t. 

Migration is the perfect opportunity to simplify. 

If you move: 

• poor data  
• duplicated records  
• inconsistent policies  
• broken processes  

…you simply recreate old problems in a bigger organisation. 

Think of it like moving house. 

Most people discover very quickly they don’t actually want to take every cable, box and broken chair into the new property. 

Councils should approach migration the same way. 

Use reorganisation and transformation to: 

• clean up data  
• rationalise processes  
• archive redundant information  
• standardise governance  

The safest migrations are often the simplest ones. 

Citizens should not feel organisational disruption. 

Unfortunately, they often do. 

During reorganisation: 

• contact volumes increase  
• confusion increases  
• ownership becomes less clear  
• response times can slow  

Citizens do not care which authority previously owned a service. 

They care whether: 

• they can contact someone  
• they receive updates  
• services still function  

This is where unified platforms become critical. 

Solutions like Microsoft Dynamics 365 Customer Engagement and Dynamics 365 Contact Centre help councils maintain: 

• consistent engagement  
• unified case management  
• shared visibility across services  

The goal is simple: 

organisational change should not create citizen confusion. 

Many councils now rely heavily on Microsoft 365 and SharePoint. 

Which sounds positive, until reorganisation begins. 

Then authorities discover: 

• multiple tenants  
• duplicated content  
• inconsistent permissions  
• poor folder structures  
• unmanaged document sprawl  

And suddenly staff can’t find: 

• policies  
• procedures  
• templates  
• operational guidance  

During reorganisation, this becomes dangerous. 

Because when people cannot locate information quickly: 

• productivity drops  
• decision-making slows  
• operational risk rises  

A successful SharePoint migration needs: 

• information architecture planning  
• metadata strategy  
• governance ownership  
• permission rationalisation  
• lifecycle management  

This is not just an IT clean-up exercise. 

It is operational continuity. 

Reorganisation creates security risk. 

Because during transition, councils often temporarily operate: 

• overlapping environments  
• shared access models  
• multiple identity structures  
• duplicated permissions  

This creates complexity around: 

• GDPR  
• retention  
• information access  
• auditability  
• compliance  

Security should never be added afterwards. 

It should shape: 

• migration planning  
• architecture decisions  
• access management  
• collaboration models  

Microsoft Modern Work capabilities help councils standardise: 

• identity  
• collaboration  
• security  
• governance  
• compliance  

…before complexity grows further.

One of the most important considerations during organisational change is supporting the people delivering services every day.

Staff are often expected to: 

• continue frontline delivery  
• learn new systems  
• adapt to new structures  
• work across unfamiliar departments  

All at the same time. 

That creates fatigue quickly. 

Technology should reduce friction, not add to it. 

This is where AI and Microsoft Copilot become incredibly valuable. 

Copilot can help staff: 

• locate documents faster  
• summarise policies  
• navigate complex information  
• reduce manual administration  
• onboard into new structures more effectively  

AI should not be positioned as replacing people. 

It should be positioned as helping overwhelmed teams regain time and clarity. 

Automation is powerful. 

But automating fragmented processes simply accelerates confusion. 

Different councils often handle: 

• approvals  
• escalations  
• records  
• communication  
• workflows  

…in completely different ways. 

Before introducing AI Agents or automation, councils should first: 

• identify best practice  
• align operating models  
• standardise governance  
• simplify workflows  

Then automation becomes transformational. 

Without this, AI simply magnifies inconsistency. 

Large-scale migration cannot happen all at once safely. 

Successful councils take a phased approach: 

1. Discovery  
2. Governance  
3. Rationalisation  
4. Consolidation  
5. Migration  
6. Stabilisation  
7. Optimisation  
8. AI Enablement  

The mistake many organisations make is trying to modernise, migrate and transform simultaneously. 

That creates operational shock. 

Phased migration protects: 

• citizens  
• staff  
• service continuity  
• governance  
• operational resilience  

The most successful councils will not stop at consolidation. 

They will use this period of organisational change as an opportunity to become:

• AI-enabled  
• insight-driven  
• collaborative  
• operationally agile  

Microsoft describes this as the Frontier Organisation. 

An organisation where: 

• AI supports daily work  
• knowledge is accessible instantly  
• staff spend less time searching  
• citizens receive faster responses  
• services continuously improve  

Reorganisation creates a rare opportunity to redesign how councils operate for the future. 

The councils that think beyond migration today will be far better prepared tomorrow.