Data Migration

Data migration is actually the translation of data from one format to another format or from one storage device to another storage device. This also necessarily requires someone or something to do the translating. Data doesn't just get up and walk to another format all by itself.

Data migration is necessary when a company upgrades its database or system software, either from one version to another or from one program to an entirely different program. Software can be specifically written, using entire programs or just scripts, to facilitate data migration. Such upgrades or program switches can take place as a result of regular company practices or as a result of directives mandated in the wake of a company takeover.

Another use of data migration is to store little-used data on magnetic tape or other backup storage methods. This data may need to be stored for historical purposes or for periodic access. Individual computer users do this all the time when they back up their data to CDs, DVDs, or external hard drives. Companies large and small do this, of course, to protect and archive their data. Migrated data typically is moved offline but remains available via network access, leaving the online environment free to conduct current business.

Data migration typically has four phases:

• Analysis of source data
• Extraction and transformation of data
• Validation and repair of data
• Use of data in the new program

During each phase, the data migration software works its electronic magic, performing the necessary machinations before moving the data on through the process. Perhaps the most sensitive phase is validation and repair. In this phase, data is evaluated for potential problems, which are flagged and identified to the user. Unresolvable problems can be identified at this stage, along with untranslatable data, so they can be set aside and not gum up the whole data migration works.