Technical Data Conversion and Migration

This book comprehensively covers the technical aspects of executing a data conversion project. While primarily intended for technical staff—including developers and analysts—within a data conversion team, it also serves as a valuable resource for the entire team and all SQL developers.The book introduces the use of design patterns in data conversion, presenting multiple patterns along with their applications and best-fit scenarios. Additionally, it explores data conversion frameworks that simplify the build and execution processes.Structured into ten chapters, each focusing on a distinct aspect of conversion, the book begins with fundamental concepts before progressing through various conversion topics. These range from data extraction, staging, gap analysis, and requirement gathering to planning sessions, design sessions, mapping, translation, cleansing, build processes, unit testing, execution, exception handling, reconciliation, documentation, verification, quality assurance (QA), and ongoing support. Read more