Energia Rewards had roughly 500,000 registered users and linked records to carry into a new platform. The difficult part was not copying rows from one database to another. Duplicate emails, inconsistent letter case, unmatched utility accounts, and incomplete registrations meant that a technically complete import could still leave customers in the wrong state.
Eleven remediation scripts dealt with known record problems before production migration. The identity plan also had to give existing customers one clear sign-in journey without assuming every legacy password hash would migrate cleanly. Four recurring joiner and leaver files needed visible status and an alert when an expected file did not arrive.
That is what modernization work often exposes. The old system is not only code. It is rules, exceptions, timing, access, and work people have quietly learned to do around it.