An Overview of Data Migration Methodology

Data migration is a common element among most system implementations. It can be performed once, as with a legacy system redesign, or may be an ongoing process as in a data warehouse. There is a common problem is with the theoretical design differences between hierarchical and relational systems. Two of the cornerstones of hierarchical systems are de-normalization and redundant storage strategies.The ideal data migration project plan has been broken into seven phases, which mirrors the overall project. These as strategy, analysis, design, build,test/implement, revise and maintain.