RLDatix Modernises Healthcare Platform with Database Partner Cintra

Overview

Business Challenge

The RLDatix Loop application operated across AWS regions using Microsoft SQL Server on RDS to meet data residency requirements. However, SQL Server licensing costs and vertical scaling constraints significantly increased cloud spend during peak workload demands and limited business growth.

Key business drivers included:

· Enhancing user experience by addressing database performance and removing bottlenecks

· Eliminating dependency on expensive SQL Server licensing

· Ensuring growth by enabling vertical and horizontal scaling

· Understanding PostgreSQL differences and modernisation complexities

· Completing the modernisation within a strict two-month timeline

· Ensuring minimal business disruption throughout the transition

RLDatix required a trusted specialist to assess modernisation viability and deliver a low-risk and rapid modernisation of the Loop Healthcare application database.

Cintra’s Solution

Cintra executed a two-phase modernisation program:

Phase 1 – Modernisation Viability Assessment (MVA)

· Assessment of the Loop SQL Server environment · Evaluation of database modernisation complexity · Target Aurora PostgreSQL architecture design · Modernisation business case, delivery plan and ROI model

Phase 2 – Database Refactoring & Migration Services

· Modernisation plan and technical design · Schema and code conversion using AWS DMS Schema Conversion Tool · Full AWS DMS-managed data migration · PostgreSQL automation provisioning scripts · SME modernisation support during testing and go-live · Knowledge transfer on Aurora PostgreSQL cloud operations

The result: a scalable and resilient, multi-region, Aurora PostgreSQL architecture with automated scaling and read replica redundancy to meet business requirements.