The Art of successful Data Migration
Data migration is often considered to be very difficult. However, TCP has extensive experience of handling many such migration projects successfully. Whilst the nature of every migration project is heavily dependent on the character of the old system, we have developed a range of standard software tools and techniques aimed at building valid SS/G data structures from legacy data.
Legacy Data Analysis
In terms of the overall Data Migration project, a number of different approaches are possible. Our preferred approach is to work with client staff familiar with the data structures and peculiarities of the old system(s) being replaced, forming one integrated team with our own staff who will be familiar with the new. A major aspect of the work here is to analyse the features of the legacy system products and their frequency of occurrence. Then for each feature, we will define how it will be represented and any related processes to be systematised in the new. However, in some cases, such as old products with capital units where their impact has long since lapsed, this analysis also reveals instances where legacy product features and processes need no longer be systematised.
Major Cost Savings Ensue
Although the data migration work involved is of a very detailed and complex character, the benefits of replacing multiple legacy systems with SS/G are fully achievable. One such project undertaken at TCP even saw us successfully consolidate twenty systems into one. Such data migration projects, dispensing with the costs of maintaining and running multiple systems, can often be the biggest area of cost savings that a client company can make.