A year after the old EMS was switched off, an inspector asks for the temperature trend behind a batch and nobody can open the file.
Replacing a monitoring system is also a data migration. The sequence that keeps the records usable:
- List what the old system holds and how long each record has to be kept: values, alarms, the audit trail.
- Specify what moves and in what form: values with time stamps and units, alarm events, the audit trail, metadata such as tag and range. Write down what will not move and how it stays readable.
- Run a trial migration and verify it: record counts per tag and month, and sampled values compared between old and new.
- Migrate under change control, with the old system set to read-only first.
- Keep the old data, and a way to read it, until the verification report is signed.
The 2011 text of EU GMP Annex 11 (clause 4.8) says that when data are transferred to another format or system, validation should include checks that data are not altered in value and/or meaning. "Meaning" is where migrations go wrong: a temperature that lost its unit, or a time stamp that moved seven hours because the old system stored Viet Nam local time and the new one UTC.
PIC/S PI 041-1 adds that migration should follow documented protocols and include verification that it is complete.
Ask for the old system's export format before the purchase order for the new one is signed.
Industries




