When implementing a new application, migrating the data from the old application requires specific steps.
It is almost certain that the data structures between the two applications will not be the same, so the data from the old application, must be extracted, manipulated, translated and imported into the new application.
In order to carry out these steps, analysis of both application’s data structures which includes interpretation of the ‘meaning’ of the data must be done, this must be documented along with the rules for the manipulation and translation, these rules must be tested and proved.
JCS has been involved in major data migration projects for GlaxoSmithKline and Novartis. Migrating data from Lotus Notes databases to Oracle and between different Oracle based applications.