|
Practical Data Migration
Practical Data Migration gives you techniques and strategies for ensuring that your data migration project achieves maximum returns for your company. This book provides a structured approach to data migration enabling you to get the right data, in the right place, at the right time. Every new computer system needs start up data before it can be put
into operation and realize the benefits implicit in new software. The success of every company merger, de-merger or restructuring relies on the success of merging or dividing data. Often, data migration goes wrong - as recently highlighted by the media in organizations as crucial as the NHS, The Inland Revenue, and the Department of Work and Pensions. To realize return on investment, data loaded at 'go live' should be the best available; to maximize the utility of the novel features of a new computer system data should also be the most appropriate obtainable. There has been no published method for finding and re-processing data in legacy systems - until now. Practical Data Migration provides tried and tested approaches, strategies and techniques for ensuring your data migration project goes smoothly with minimal disruption to your organization. Practical Data Migration is not slanted towards any particular operating system, target system, data migration tool or industry. It is a business facing approach that will work, and has worked, in any business environment. This is a practical guide to running successful data migration projects containing original methods, an example project as a model of best practice and ideas on rescuing data migration projects that have gone wrong. Practical Data Migration contains a wealth of real life examples and hints that have been shown to work in practice. It explains how to maximize the benefits of data migration, both as part of a new system implementation and as a key tool in business merger and de-merger activities. It blends real life experiences, with cutting edge developments from the Rapid Application Development arena, as well as more traditional metadata modelling concepts, and offers clear definitions of commonly used jargon that surrounds the subject. Practical Data Migration debunks the mysteries that surround this subject, providing a template for judging the performance of in-house or brought in skills. It encourages adaptation to local cultural or environmental constraints, but provides a model of best practice that should be the starting point for their project specific implementation of the method. For the IT practitioner who has been given responsibility for managing a data migration project, it provides techniques well-founded in practice, a host of hints and tips and anecdotes to reassure that the author has been there, done that .
Contents:
Introduction What is the purpose of this book What Type Of Data Migration Is Covered? What Is Not Covered In This Book? Who is this book aimed at? Worked Example Paragraph Styles Part One - Reasons and Methods Chapter 1 - Reasons Why Quality Data Migration Matters A Practitioners Perspective Chapter 2 - The Golden Rules The Most Important Lessons Chapter 3 - Data Stakeholders The Commuter and The Knight Errant Ownership Finding The Right Fellow Travellers Chapter 4 - Four Key Concepts First A Health Warning Key Business Data Areas Legacy Data Stores System Retirement Policies Data Transitional Rules Chapter 5 - Data Quality Rules Introducing Data Quality Rules A typical Data Quality Rule Document Introduction Data Quality Assessment Method Statements Generating Data Quality Rules Chapter 6 - Data Gaps and Data Mapping Health Warning Standard Data Migration Terms Data Gaps Analysis Data Mapping Chapter 7 - Non Functional Requirements Fallback Part Two - Specimen Project Chapter 8 - Project Overview Introduction Specimen Project Overview Why A Separate Project? Back To The Example Project Use of Iteration Project Control points and planning Chapter 9 - Stage 0 Project Initiation Introduction Standard Project Initiation Deliverables Create Your Own Data Migration Strategy First Cut Project Plan Set Up An Appropriate Project Support Office Function Initial Lists of Data Store Owners, Legacy System Data Stores, and Key Business Data Areas
Stage 0 - Closedown Stage 0 - Project Control Points Chapter 10 - Stage 1 Data Preparation Step 1.0 - Stage Initiation Step 1.1 - Analyse Legacy Data Stores Step 1.2 Update Key Business Data Area Models 1.3 Create First Cut System Retirement Policies 1.4 Create Data Quality Rules 1.5 Enact Data Quality Rules Data Transitional Rules Transitory Data Stores Use Of Recursion Stage 1 Closedown Stage 1 Project Controls Chapter 11 - Stage 2 Data Preparation Step 2.0 - Stage Initiation Step 2.1 - Nominate Candidate Legacy Data Stores Step 2.2 - Create Second Stage Data Quality Rules Step 2.3 Enact Data Quality Rules Step 2.4 - Enhance System Retirement Policies Data Transitional Rules Transitory Data Stores Stage 2 Closedown Stage 2 Project Controls Chapter 12 - Stage 3 Build, Test and Go-Live Stage 3 Overview Step 3.0 - Stage Initiation 3.1 - Physical Design of Migration Step 3.2 - Data Migration Testing 3.3 Building The migration Software 3.4 Execute the Migration 3.5 Post Implementation Review Stage 3 Project Controls Part 3 - Rescuing Data Migration Projects Chapter 13 - Data Migration Projects That Have Gone Wrong - A Survival Guide Introduction Stabilisation Planned Activity Post Implementation Mop Up Conclusion
|
