Planning for a migration of data from one system to another should follow System Development Life Cycle (SDLC) standards for project management and breakdown of essential elements of a plan. The process is centered on a methodology that defines the objectives of the project, task descriptions, business or project prerequisites, defining deliverables and establishing a project management plan for completing the objectives. It is a life cycle or process that is geared toward fast and accurate migration and development of higher quality systems, ready for deployment in a crucial situation: the continuation of business processes after the migration.

To successfully move data from on system to another

The project team must have knowledge of the existing system in detail. Skills in programming, both the existing legacy system and the target system must be an integral team member. Development of front-end applications for users and training support on the new system is critical to the success of the project. Skilled project management is crucial to initial planning phases and through out the project to assure tasks are completed and reported on in a fashion that allows the team and management to follow the progress of the project.

Shepherd, John B. (1999). Data Migration Strategies. DM Review.

The objectives of the project must be well defined and supported by senior management. Creating business objectives is a first step for establishing the scope of the project.

Dependency profiling looks at data by comparing values between rows. This process uncovers relationships within tables of the database. Primary keys will be identified as well as relationships that are true in varying times or relationships.

Normalization of data within the context of a relational model is an absolute. Through the profiling processes redundancies are identified within data across tables and this process will eliminate data redundancy.

There are many other factors that will affect the success or failure of the migration project. Some of these are the understanding of the dat

Some common words found in the essay are:
John Shepherd, Critical Factors, Team Skills, Cycle SDLC, Strategies Preparing, Summary Data, Planning ERP, , Elements Planning, project management, DM Review, data migration, analysts project, business analysts project, preparing data, migration critical, meta data, business analysts, data profiling, life cycle, data system,
Approximate Word count = 931
Approximate Pages = 4 (250 words per page double spaced)