Pharmacy data migration
A converter that moves a pharmacy’s entire history out of a legacy system and into Box, proven on real pharmacies with zero failed records.
Overview
Switching pharmacy software means bringing years of records with you. I built the migration that carries patients, prescribers, care homes, insurance plans, prescriptions, claim history, compounds and inventory out of a legacy pharmacy system’s SQL Anywhere database and into Box’s PostgreSQL.
What I built
The full record
Every entity a pharmacy depends on, converted and linked back together on the other side.
Dry run first
A dry-run mode writes everything out for review before a single record is inserted.
Under the hood
Zero failed records
Validated on real pharmacies, including one with hundreds of thousands of prescriptions, without a single failed insert.
Messy data, handled
Found and documented quirks the old system hid, like insurance plan IDs that are only unique within a single insurer.
Built with
Next project
Office server & network build
A new HPE ProLiant server running Windows Server 2025 for a 20+ person office, with shared file storage, a rebuilt mesh Wi-Fi network and every employee laptop set up.
View project