Steps in a User-Oriented Approach to Data Migration   Establish the business benefits of the proposed Migration. Attend stakeholder workshops to agree data to be migrated. Support design walkthrough and User Scenarios for potential software package. Identify the preferred package. Draft the Business Rules for Data Validation, Clean-up and Transformation. Review the Business Rules with Users and modify according to User comments. Obtain formal User sign-off for the Business Rules. Define the End-to-End Data Load Processes, including procedures for resolving data quality discrepancies. Select Data Modelling Tool,in accordance with relevant Standards. Create Data Models for Sources and Targets. Define procedures to maintain the Data Model as detailed in the Requirements Specification under Change Control (following system design changes) Complex Change Management Projects. Carry out data preparation to defined business rules for data input. Carry out data cleansing to defined business rules for data input. Support data input processes, including resolving data quality queries. A. Setting-up the Data Migration Process ... Define the Business Rules for Data Validation, Cleansing and Transformation. Define the Business Rules for Data Input. Carry out data cleansing to defined business rules for data input. Support data input processes, including resolving data quality queries. Choose a Data Modelling Tool with Reverse Engineering Capability,(such as ERWin). Identify all the required Data Sources, and an 'owner' for each Source. Data Feeds Legacy Systems Operational Data Stores Define the Data Items required, in consultation with the Users. Create the Data Models for the Source Data. B. Executing the Data Migration Process. Optionally, choose a Data Migration Tool. Create Extract Files for each Data Source in turn. Resolve any Errors with the Users. Create Extract and perform Data Clean-Up. Complete the Migration, (Extract, Transform and Load) for each Data Source. Run Acceptance Tests on the Integrated Target Database,(esp. Referential Integrity).