You are previewing Practical Data Migration.
O'Reilly logo
Practical Data Migration

Book Description

This book is for executives, practitioners, and project managers who are tasked with the movement of data from old systems to a new repository. It uses a series of steps developed in real life situations that will get the reader from an empty new system to one that is populated, working and backed by the user population. This new edition of the primary text on the subject is updated to take account of changes in technology and the maturing of the market for Data Migration services. The most recent figures suggest that nearly 40% of Data Migration projects are over time, over budget or fail entirely. Using the proven methodology in Practical Data Migration will vastly increase the chances of achieving on time, on budget, and zero defect migrations.

Table of Contents

  1. FRONT COVER
  2. HALF TITLE PAGE
  3. BCS, THE CHARTERED INSTITUTE FOR IT
  4. TITLE PAGE
  5. COPYRIGHT PAGE
  6. DEDICATION
  7. CONTENTS
  8. FIGURES AND TABLES
  9. AUTHOR
  10. ACKNOWLEDGEMENTS
  11. ABBREVIATIONS
  12. GLOSSARY
  13. USEFUL WEBSITES
  14. INTRODUCTION
    1. What is the purpose of this book?
    2. What types of data migration are covered?
    3. What is not covered in this book?
    4. Who is this book aimed at?
    5. What is new to version two of Practical Data Migration?
    6. Paragraph styles
  15. SECTION 1: EXECUTIVE OVERVIEW
    1. 1 DATA MIGRATION: WHAT’S ALL THE FUSS?
      1. What is data migration?
      2. First the bad news
      3. So what usually goes wrong?
      4. The responsibility gap
      5. How to avoid the responsibility gap
    2. 2 GOLDEN RULES AND SUPER SMART TASKS
      1. Golden Rules: the most important lessons
      2. Golden Rule 1
      3. Golden Rule 2
      4. Golden Rule 3
      5. Golden Rule 4
      6. Super SMART Tasks and the mid-change cycle slump
    3. 3 PDMv2 OVERVIEW
      1. Introducing PDMv2
      2. Introducing the technology
      3. Technology overview
      4. The case for specialist technology
      5. PDMv2 provides all the answers
    4. 4 CREATING A MIGRATION STRATEGY
      1. Starting out on the right foot
      2. PDMv2 data migration strategy
      3. What is in a PDMv2 data migration strategy document?
      4. Data migration strategy checklist
      5. Getting the data migration strategy implemented
  16. SECTION 2: TOOLS AND TECHNIQUES
    1. 5 METADATA AND KEY BUSINESS DATA AREA DECOMPOSITION
      1. Metadata and PDMv2
      2. Uses of data models in PDMv2
      3. Instantiating data models
      4. Developing a conceptual entity model
      5. Project decomposition and key business data areas
    2. 6 DEMILITARISED ZONES AND KEY DATA STAKEHOLDER MANAGEMENT
      1. The impact of the demilitarised zone
      2. Introduction to key data stakeholders
    3. 7 LANDSCAPE ANALYSIS
      1. What is landscape analysis and why do you do it?
      2. Legacy data stores
      3. Landscape analysis as a Super SMART Task
      4. When to perform landscape analysis
      5. Documenting legacy data stores
      6. Profiling, data gaps and master data management
      7. Software tools to support landscape analysis
      8. Impact of the DMZ
    4. 8 SYSTEM RETIREMENT PLAN
      1. Why have a system retirement plan?
      2. What are system retirement plans?
      3. How and when to implement SRPs
      4. SRP minimum requirements
      5. SRPs and Super SMART Tasks
      6. Impact of the DMZ on SRPs
    5. 9 DATA QUALITY RULES
      1. Introducing data quality rules
      2. How do you generate DQRs?
      3. The DQR process
      4. How a DQR board works
      5. Software support
      6. Role of the DMZ
    6. 10 GAP ANALYSIS AND MAPPING
      1. Gap analysis
      2. Gap analysis as a service
      3. Data quality monitoring as a service
      4. Mapping
      5. Data lineage, data audit and the ‘one-way street’ problem
      6. Impact of the DMZ
      7. Software support
    7. 11 MIGRATION DESIGN AND EXECUTION
      1. Migration end-to-end design
      2. Extract, transform and load designs
      3. Detailed decommissioning design
      4. Migration build, test and execute
    8. 12 LEGACY DECOMMISSIONING
      1. Executing the decommissioning design
  17. SECTION 3: FAILING DATA MIGRATION PROJECTS
    1. 13 RESCUING FAILING DATA MIGRATION PROJECTS
      1. Introduction
      2. Stabilisation
      3. Planned activity
      4. Post-implementation mop-up
      5. Impact of the DMZ
      6. Conclusion
  18. APPENDICES
    1. A1 CONFIGURABLE ITEMS
    2. A2 IMPACT ANALYSIS FRAME
    3. A3 DATA MIGRATION STRATEGY CHECKLIST
    4. A4 SPECIMEN DQR FORM
    5. A5 DATA MAPPING EXAMPLE
  19. BACK COVER