July 9, 2026
Three months after go-live. The provost asks for ten-year alumni giving by class. Class of 2017 returns zero records. Class of 2018 returns zero. Three classes - eleven thousand alumni -missing.
The migration team had extracted from the old Raiser's Edge instance. They documented one Account object. Nobody asked about the Soft Credits table linked to Affiliation records. Nobody asked about the lapsed-donor archive split off into a second database six years ago. Eleven thousand alumni existed in tables; nobody enumerated.
This is what happens when legacy migrations treat the source as one database instead of an archaeology dig. Custom tables, archived records, soft credits in junction objects, linked attachments in network folders. Every legacy system has its own debris. Migrating only what's visible loses what isn't.
The fix is a structured, step-by-step migration discipline - assessment, extraction, cleansing, transformation, staged load, validation, cutover - with FERPA controls and validation gates that surface every record before go-live.
Here's the step-by-step guide for migrating student data from legacy systems to Salesforce.
Six failure modes that surface months after go-live.
Each is preventable. Together, they erase trust in the new platform before adoption begins.
Five questions every migration team answers before extraction.
The assessment becomes the migration's source of truth. Skip it, and the migration runs on guesses.
Extract from every source system into a staging environment. SQL exports, CSV dumps, API pulls. Each source extracted to its own staging table for traceability.
Deduplicate by name, email, phone, external ID. Standardize formats - dates, addresses, phone numbers. Flag records with missing required fields for manual review.
Map every source field to its Salesforce target: Account, Contact, Education Cloud Application object (managed), Opportunity-based Gift records (NPSP/Fundraising), and custom objects. Confirm whether the target org uses the current Education Cloud managed data model or the legacy EDA schema - this determines which Application object to load into.
Build transformation rules - picklist translations, date format conversions, phone normalization, custom logic for legacy quirks. Run in staging, not production.
Load transformed data into a Partial Copy or Full Sandbox (Full Sandbox preferred for highest fidelity; Partial Copy is adequate for most validation workloads and more widely available depending on org licence). Run validation queries - record counts, field completeness, relationship integrity. Reconcile against source counts.
Validation failures feedback to cleansing and transformation. Reload the sandbox. Re-validate. Repeat until variance is below the institution's defined threshold.
Production load runs during scheduled downtime. Pre-defined load order, monitored execution, rollback plan if validation gates fail. Post-load smoke tests before users gets access.
Six validation gates run between extraction and production cutover.
Source count must match staging count must match Salesforce count. Any variance investigated before the next step.
Every required field is populated. Fields with high null rates flagged. Critical FERPA-protected fields validated for accurate population.
Account-to-Contact links, Gift-to-Constituent links, Application-to-Student links - every junction object validated for completeness.
Salesforce's duplicate rules run post-load. Matches across migrated records flagged for resolution. Soft credit and household merges reviewed manually.
Every migrated field target Field-Level Security matches its FERPA classification. No misclassifications enter production.
Admissions, advancement, registrar, and IT teams sample migrated records and verify usability before go-live signoff.
"A migration without validation gates between every step is hope. Add the gates, and the migration becomes a discipline."
Five decisions every cutover plan must make.
Schedule downtime when usage is lowest (weekends, term breaks). Or use change-data-capture from the legacy system - feeding incremental updates into Salesforce via MuleSoft or an ETL pipeline — to keep the two systems in sync until the final cutover window, minimizing downtime.
Big bang: all users on Salesforce on Day 1, legacy system off. Phased: rolling user groups; legacy stays read-only for weeks. Higher-ed institutions usually phase by department.
Keep legacy systems read-only for thirty to ninety days post-cutover. Users reference historical data without write access; reduce cutover pressure.
First two weeks post-go-live, a dedicated support team monitors errors, fields of user questions, and patches critical issues fast.
Pre-define what triggers a rollback - data integrity failures, system unavailability, critical workflow breakage. Decision points at sandbox sign-off, production load completion, post-load smoke test, day one.
Six rules every migration engagement should follow.
Every migrated record carries its legacy ID as an external ID, enabling future audits, delta loads, and reverse lookups to source system records.
Every step, every transformation, every decision logged in a runbook reviewed by IT and compliance.
How long does the legacy system stay accessible read-only? When does it get archived? ow long does the legacy system stay accessible read-only? When does it get archived? When is it decommissioned or its data destroyed per institutional records retention policy? Define all three before cutover, not after.
Migration team access to Salesforce production granted per the cutover window, revoked at sign-off. Standing access creates audit findings.
Compliance officer reviews migrated FERPA records, profile permissions, and Field-Level Security before user access opens.
Every load operation, every reconciliation, every rollback decision logged with timestamp and user. Audit trail retained per institutional records of retention policy.
"Migration projects are short. The records they create live for decades. Discipline today is the audit trail of tomorrow."
Mid-size institution from one legacy CRM to the Education Cloud: four to six months. Larger institutions with multiple sources, advancement data, and SIS integration: six to twelve months. K-12 districts with custody and household model complexity: add three months.
Salesforce Data Loader for small-to-mid volumes; Salesforce CLI (sf) for ad-hoc developer operations; ETL tools (Talend, Informatica, Boomi, MuleSoft) for complex multi-source migrations; Salesforce Bulk API 2.0 for large-volume loads.
Depends on institutional policy and FERPA retention requirements. Active records always. Archived records - graduated from alumni twenty years ago, expired applications - often migrated to an archive object or external archive. What to migrate vs. archive depends on the institution's records retention policy and applicable state law - not FERPA alone. FERPA governs access and disclosure; state statutes and institutional policy govern how long records must be kept. Confirm retention schedules with the compliance or records management office before scoping the migration.
Validation queries - record counts, field completeness, relationship integrity - run via Salesforce Reports and SOQL. Most institutions have SQL skills internally. Complex transformations and ETL work usually require consultant or specialized migration team experience.
Legacy migration to Salesforce is where institutions either inherit clean data or import their old problems. Seven migration steps, six validation gates, five cutover decisions, six project validation rules. The discipline isn't glamorous - assessment, cleansing, mapping, sandbox loading, validation, production cutover - but it's the difference between users trusting the new platform and reverting to old workflows.
Minuscule Technologies is a Trusted Salesforce Engineering Partner with 160+ Salesforce experts and 75+ projects delivered globally - including Nasdaq-listed enterprises across BFSI, manufacturing, IT services, and higher education. We migrate higher-ed and K-12 institutions from Raiser's Edge, Slate, TargetX, legacy Salesforce Orgs, PeopleSoft, Banner, and homegrown CRMs to Salesforce - with FERPA-aware mapping, six-gate validation, and cutover runbooks that survive audit - anchored by the Minuscule Education Starter Pack on the Salesforce side.
Plan your legacy-to-Salesforce migration with us, and we'll review your source systems, data quality baseline, FERPA classification, and the migration plan that fits your timeline.
You've seen what's possible. Now, let's make it happen for your business. Whether you need an end-to-end Salesforce solution, a complex integration, or ongoing managed services, our team is ready to deliver.
Schedule a Free Strategic Call
