Successful large-scale data migrations are underpinned by a clear strategy, informed by expert analysis of a range of critical factors
Data migration should always be undertaken early and continuously using an approach tailored to the data volumes, transformation complexity and cutover time targets.
The criticality of data migration process means that any quality issues are likely to have a disproportionately high impact on the success of the project. BJSS has developed a range of techniques for ensuring that data integrity is maintained – a multi-layered approach mitigates the risk of data integrity issues being overlooked by any single technique
BJSS loaded backups into the UAT server and completed the migration in yearly phases. Results were checked and automatic row counts implemented. Once certain of the integrity of the migration, it was moved to the production server. Today data is stored in a single partitioned database that utilises a relational model.
The replacement system provides substantial manpower, processing and cost savings. Its new code base is much smaller and simpler and changes are easier to implement. The migrated data, which dates back to the late 1980s, is able to be quickly and efficiently mined, allowing the client to benefit from quick and insightful reporting.