Database design & migration

Schema design, normalisation and migrations off legacy Access, Excel or ageing SQL Server instances — with reconciliation reports proving nothing was lost in transit.

Access databases that have quietly become load-bearing. Excel files with more macros than anyone remembers writing. SQL Server instances nobody's patched since the person who set them up left. We profile what's actually in there, design a schema that won't need doing again in two years, and migrate with row-level reconciliation evidence — a report proving every row that existed before the move still exists after it.

What's included

• Data profiling and quality report
• Zero-downtime cutover plan
• Row-level reconciliation evidence
• Backup, retention and recovery drills

Who this is for

Any business where "the database" is a single file on someone's laptop, or a server nobody wants to touch in case it breaks.

We can't replace our current system outright.

Most of our work sits beside something that already exists. We integrate or migrate incrementally — a big-bang replacement is rarely the right call, and we'll say so.