Practical Data Migration How to enjoy a migration experience John Morris
What’s Coming Up • Who am I? • Migration – The Big Opportunity • Migration – The Big Risk • Industry Standard Migration Model • The New Model • Questions?
Who Am I? • John Morris • 20 plus years in IT • 9 years specialising in Data Migration/Integration • Joint founder of iergo ltd • Author of “Practical Data Migration”
Migration The Big Opportunity • Realising the business case • Making full use of new features • De-risking the project • Realigning technology with enterprise values • Building bridges with the business • Adding value • Whatever your drivers are • ROI • Governance/Compliance • Project Control
Migration - The Big Risk • Tales of migrations that have gone wrong…….. How can we prevent this happening and realise all the good things?
Source Applications ETL Rules Re-try Load Tool Business Users Industry Standard Approach Errors Target
Source Applications ETL Rules Re-try Load Tool Industry Standard Approach • Blue Sky • Well formed and ill-formed problem domains • Emphasises technical over business • Lacks project control leading to uncontrolled recursion “All too often Migration projects start with the technical and end in disaster” Errors Target
Case History Example • The Challenge: • Half the budget was spent building an ETL tool • The users rejected the quality of the data • The users rejected the data source selection • The users rejected the appropriateness of the solution to their environment
Case History (cont) Dramatic improvements when we altered the project drivers: • Put business issues first • Natural division of opinion about where the best data lies • Natural division of opinion about definition of business objects • All of this is already resolved in the business • Get this knowledge out of the business and into the project
The New Model • Not just about moving data from one place to another • Realising all the benefits promised by the software salesman • Adding value • Improving business performance
Golden Rules Golden Rule 1 Data Migration is a Business not a technical issue. Golden Rule 2 The Business knows best Golden Rule 3 No enterprise wants, needs or will pay for perfect quality data Golden Rule 4 If you can’t count it, it doesn’t count
Legacy Data Store System Retirement Policies Data Quality Rules Tool Kit of Techniques
Project Controls New Supporting Techniques Project Initiation Legacy Investigation Qualify Legacy Fit Introduce New Model Migration Design Migration Build & Deploy
Project Controls New Supporting Techniques Source Applications ETL Rules Errors Re-try Load Tool Project Initiation Legacy Investigation Qualify Legacy Fit Introduce New Model Industry Standard Approach Migration Design Migration Build &Deploy