Business Central Migration Strategy: A UK Guide
A Business Central migration strategy decides what moves, how it moves and how you prove it worked. Here is how UK finance teams should scope, choose a route and test it.
A Business Central migration strategy is the short document that decides what you move, how you move it and how you will know it worked. For UK finance teams leaving Dynamics NAV, Dynamics GP, Sage or QuickBooks, most of the risk is settled before any data is touched.
This guide sets out the decisions to make first and the order to make them in.
Key PointDecide what moves, how it moves and how you will prove it worked before any data is touched.
Why a migration needs a strategy
Migrations rarely fail on the technology. They fail on scope that keeps growing, data nobody tested and teams that were not brought along.
A written strategy forces early answers: what moves, what stays behind, who signs off and what done looks like. Agree those answers before the work starts, so the project stays honest when go-live pressure builds.
Know your starting point and your route
Your route depends on where you start. Microsoft's guide to migrating on-premises data to Business Central online sets out the options:
- Dynamics NAV: upgrade to Business Central on-premises first, then switch to Business Central online.
- Business Central on-premises: version 25 and later migrates directly; versions 15 to 24 upgrade to version 25 first.
- Dynamics GP or Dynamics SL 2015 and later: covered by Microsoft's cloud migration tools.
- Other SQL databases: custom migrations.
- Non-SQL sources such as spreadsheets: configuration packages and templates, then the cloud migration tool.
If you are coming from Sage 50, our Sage 50 migration guide covers that route. If you are already on an older Business Central version, read our Business Central upgrade guide.
Scope the data and the processes
List every system that feeds your ledgers today, from the old ERP to the spreadsheets and bolt-ons around it. Then decide how much history you need in the live system and where older history will be kept.
Keep the retention rules in view when you decide. GOV.UK says a limited company must keep its company and accounting records for 6 years from the end of the last financial year they relate to.
Map your core finance processes too. A migration is the right moment to retire workarounds rather than rebuild them. Our data migration process guide goes through each data type.
Pro TipDecide where older history will live before the first data load, not after it.
Choose phased or big-bang
A phased approach moves modules or companies in stages. It spreads the risk and lets people learn gradually, but you run old and new side by side for a while.
A big-bang cut-over is quicker and cleaner, but it needs thorough testing and a firm fallback plan. The right choice depends on your reporting cycle, how much parallel running you can staff and how much month-end pressure you can absorb.
Rehearse, reconcile and train
Rehearse the data load in a sandbox environment, not in production. After each rehearsal, reconcile the trial balance, open items and VAT figures against the old system and get finance to sign them off.
Check that VAT keeps working across the change. GOV.UK says all VAT-registered businesses should now be signed up for Making Tax Digital for VAT, so plan your first return from Business Central before go-live.
Pair the testing with role-based training on each team's own work. A technically perfect migration still stalls if nobody can raise an invoice on day one.
Watch OutNever run the first migration in production. Rehearse in a sandbox and reconcile before you sign off.
Turn the strategy into a plan
A good strategy fits on one page. Name the sponsor, fix the scope, choose the approach, schedule the rehearsals and define success in numbers you can check.
For the step-by-step view, read our practical guide to Business Central migration. For independent guidance on finance systems, see the ICAEW technology resources.
If your business already holds Business Central licences but has not gone live, our BC Fast-Start takes you live in twelve weeks for £4,500 fixed, with configuration, data migration, training and go-live support included.