When planning a database migration, understanding what needs to move is only half the battle. The real challenge often lies in understanding how much effort it will take to remediate incompatible queries, data structures, or application logic. For teams tackling refactoring while engaged in a database migration this complexity can be unpredictable.
To solve this, I created the Remediation Scoring Model, a practical framework to estimate and track the effort required to rewrite or replace code features that are not directly supported in the target environment.
What Is the Remediation Scoring Model?
The Remediation Scoring Model breaks down each discovered incompatibility into three categories:
- Easy – Straightforward fixes that take less than an hour to implement
- Medium – Moderately complex changes that may involve query rewriting or scheduled jobs
- Hard – Involved rewrites requiring architectural decisions, schema redesign, or custom logic
Each category carries a corresponding weight. The scoring formula is simple but effective:
Weights are adjustable based on your team’s familiarity with source/target database, project timelines, or migration tooling.
Why Use It?
Traditional lift-and-shift assessments often ignore remediation overhead, which can derail even the most well-funded migrations. This model provides:
- Effort Transparency: Understand exactly what parts of the workload require remediation
- Prioritization Insight: Focus on high-impact, high-effort items first
- Resource Forecasting: Accurately allocate developers and time to tasks
Used in tandem with our Migration Viability Score, the model helps organizations decide not just if they should migrate, but what it will take to succeed.
Normalizing for Scale
I also provide support normalizing the score, a useful approach when comparing workloads of vastly different sizes.
This allows teams to analyze remediation effort per unit of code or per operation, making it easier to compare microservices, modules, or datasets on an equal footing.
Supporting Tools
I have provided a downloadable spreadsheet version of the scoring model, complete with:
- Weighted formula calculations
- Remediation level breakdowns
- Fields for projected vs. actual remediation effort
- Built-in charts and spider graphs for visualization
This allows teams to track migration challenges in real-time, continuously refine estimates, and ensure migrations stay on budget and on time.
Get Started
If you’re running a database migration, or even considering one, this model is built for you. You can download the full toolkit or request a walkthrough tailored to your environment.
It’s time to take the guesswork out of migration effort.
OraMatt: YABAOracle 
Leave a comment