Large-Scale EMR Data Migration from Cerner Millennium to Health Insights

The Challenge

A leading Orthopaedic and Sports Medicine healthcare organization in the Middle East operated a highly complex clinical environment managing large volumes of patient, imaging, rehabilitation, and sports medicine data across multiple departments.

As part of a strategic modernization initiative, the organization decided to transition from Cerner Millennium to the Health Insights EMR platform to improve clinical data accessibility, reporting flexibility, interoperability, and long-term system sustainability.

Problem Overview

The transition presented exceptional scale and complexity.

Data Volume & Complexity

• • • • 40 TB of structured legacy EMR data
      • 100 TB of CAMM imaging files
      • 50 million scanned clinical documents
      • 68+ million clinical results records

The Migration Required:

• • • • Zero data loss
      • Full auditability
      • Business continuity during cutover
      • Regulatory compliance (HIPAA-equivalent controls and local MoPH reporting requirements)

Technical Risks

• • • • Encrypted BLOB storage in Cerner
      • Legacy CAMM image formats
      • Need for incremental live data synchronization
      • Field-level compatibility mapping between source and destination models
      • High-performance cutover within a limited downtime window

Failure would have risked operational disruption, regulatory exposure, and clinical access gaps.

Migration Requirements

Aspetar mandated:

• • • • Complete raw data extraction into a secure staging layer
      • Transformation of qualified patient data into Health Insights
      • Creation of a secondary analytics repository for regulatory reporting
      • Daily incremental refresh from Cerner production
      • Decryption and preservation of encrypted clinical BLOB data
      • Conversion of CAMM files into readable formats
      • Comprehensive data validation before go-live

Santeware’s Solution & Approach

Santeware assembled a specialized migration task force including:

• • • • Data Solution Architects
      • Cerner EMR Specialists
      • SQL & ETL Engineers
      • Dedicated QA and Validation Teams

A structured, steering-committee-approved migration framework was established prior to execution.

Architecture & Execution Model

1. System Compatibility & Field-Level Mapping

• • • • Detailed comparison of Cerner schema to Health Insights data model
      • Column-by-column validation
      • Business-rule alignment workshops

2. ETL & Data Pipeline Engineering

• • • 18 ETL packages covering 126 raw Cerner tables
    • Daily refresh of staging environment from Cerner production
    • Transformation into 63 normalized tables in a dedicated “Trans” layer
    • Snowflake schema implementation for structured analytics

110 structured views were exposed for seamless ingestion into Health Insights.

3. Handling Complex Data Types

• • • In-house utility developed for CAMM image conversion
    • Secure extraction and decryption of encrypted BLOB data
    • Metadata-linked file reconstruction to preserve clinical context

4. Multi-Layer Data Validation Framework

Santeware implemented a multi-phase QA strategy:

• • • Small-scale validation
    • Large-scale validation
    • Full-volume testing
    • Cutover simulation
    • Mirror-to-mirror MRN verification

Validation reports included:

• • • Data Load Integrity Reports
    • Testing Artefacts Reports (visual + extracted comparison)
    • Categorical Inspection Reports (patient type, gender, payer class, etc.)

A total of 89 issues were identified and resolved during pre-production testing.

Data Migration Scale

• • • 279,000+ patient demographics records
    • 35M+ encounters
    • 2M+ procedural orders
    • 7M+ clinical results
    • 17M+ dynamic clinical documents
    • 50 TB historical dataset migrated in 4.5 hours during final cutover

Post-go-live: Only two minor business-logic-related adjustments were required — none attributed to migration defects.

The Impact

The migration achieved full operational continuity with measurable execution precision.

• • • 100% successful EMR data migration
    • 0% data loss
    • 5-hour optimized cutover window for 50 TB data transfer
    • 18 ETL packages and 40 transformation stored procedures deployed
    • 110 structured views enabling seamless downstream ingestion
    • Secondary data warehouse enabling MoPH regulatory analytics
    • Entire project completed within 7 months

The new environment became self-descriptive and query-friendly, enabling non-Cerner stakeholders to retrieve structured clinical insights efficiently.

Conclusion

Santeware executed one of the region’s most complex EMR migrations by combining structured governance, high-performance ETL engineering, deep Cerner expertise, and rigorous validation controls.

The project delivered:

• • • Seamless transition to Health Insights
    • Regulatory-ready analytics infrastructure
    • Secure decommissioning pathway for Cerner
    • Zero disruption to clinical operations

Aspetar has continued collaboration with Santeware for ongoing data management and system initiatives, reinforcing long-term partnership confidence.