Practical Data Migration

List of Figures and Tables

Table

Figure 0.1	Worked example of the basic problem	4
Figure 2.1	Sufficient for purpose data	22
Figure 4.1	Conceptual entity model	43
Figure 6.1	New system equipment entity relationship diagram	79
Figure 6.2	Equipment Legacy Data Store	80
Figure 6.3	Owner Legacy Data Store	81
Figure 7.1	New product structure	115
Figure 7.2	The ‘One Way Street’	115
Table 6.1	New system Equipment table layout	85
Table 6.2	Equipment Item Type table	86
Table 6.3	Equipment Type table	86
Table 6.4	Equipment Type cross-reference table	86
Table 6.5	Equipment cross-reference table	88
Table 6.6	Location cross-reference table	89
Table 6.7	Whole Data Mapping table	94
Table 12.1	Reviewing and sign off allocation	179