Fictional worked example · CSVtoCSA editorial

Cloud migration: preserve a usable quality record

An organization migrates ten years of eQMS records into a new cloud platform and plans to retire the old service. Users must retrieve historical CAPAs, attachments, approvals, linked changes, and relevant history for ongoing quality work and inspections.

Published 12 September 2026 · Context updated 21 September 2026 · Version 2.0

All organizations, identifiers, test results and decisions in this example are fictional teaching material.

Information available and assumptions

The organisation has a controlled inventory of retained records, attachments and relationships. Retention requirements and authorized retrieval needs are established locally.

Scope and decision record

Standard case study record

Scope and decision fields

Read these fields before the detailed worked case. All organizations, identifiers, test outcomes, and decisions are fictional teaching material.

GxP Assessment
The migration preserves retained quality records needed for ongoing work and inspection. Completeness, relationships, signatures, chronology, and retrievability are GxP-relevant.
Change or Issue
Ten years of eQMS records move to a cloud platform before retirement of the legacy service.
Functions Affected
  • Record extraction and loading
  • Attachment and parent-record relationships
  • Identity, signature, and time interpretation
  • Search, retrieval, export, and archive access
Potential Impact
A required quality record may be incomplete, misleading, associated with the wrong parent, or unavailable when needed.
Deviations / Known Issues
Matching record counts conceal mislinked attachments in the fictional execution. The key strategy is corrected and relationship reconciliation is expanded.
In this example

Situation and intended use

An organization migrates ten years of eQMS records into a new cloud platform and plans to retire the old service. Users must retrieve historical CAPAs, attachments, approvals, linked changes, and relevant history for ongoing quality work and inspections.

Define the record before transferring it

Inventory record types and relationships. Identify historical states, exceptional records, attachment formats, signatures, user identities, and time representations. Decide which information remains in an archive and how users will retrieve it after the old service ends.

Evidence design

Counts help detect missing records but do not prove content and relationships. Combine population-level checks where feasible with risk-informed detailed review and justified coverage of exceptions. Define reconciliation rules and tolerances before execution; do not invent a convenient tolerance after mismatches appear.

CheckWhat it can reveal
Record counts by type and stateMissing populations or unexpected duplicates
Field and content comparisonsAltered values or truncated text
Relationship checksAttachment or approval associated with wrong parent
Historical retrievalRecords inaccessible under the intended archive workflow
Identity and time interpretationLost approval meaning or misleading chronology
Exception reviewUnsupported formats, orphan records, unresolved failures

Worked outcome — fictional

All main-record counts match. Detailed checks find that several attachments are linked to the wrong CAPA because the migration used a nonunique display number. The team corrects the key strategy and expands reconciliation to the affected relationship population. It does not accept matching counts as sufficient evidence.

Cutover and release

Define source freeze or controlled delta handling, final reconciliation, authorized go/no-go decision, user access, support, and recovery. Test retrieval through the intended post-retirement route before terminating the legacy service. Keep unresolved exceptions visible with their impact and disposition.

Ongoing responsibility

Assign an archive owner. Monitor retrieval issues and format/access changes. A cloud contract does not transfer accountability for understanding and retrieving the organization’s records.

Challenge: Is a PDF export of every CAPA enough?

Worked answer: Only if the approved record and retention assessment supports that representation and retrieval arrangement. Examine attachments, relationships, relevant metadata/history, signatures, and interpretability before deciding.

Limitations and unresolved questions

Cutover remains conditional on correction and expanded reconciliation, including attachments and retrieval. Matching row counts alone do not establish migration success.

Relevant regulations and guidance

These sources apply within their stated scope. The suggested worksheet fields, test designs and fictional decisions are practitioner recommendations, unless a source requirement is expressly identified. Completing a template does not establish compliance.

Computer Software Assurance for Production and Quality Management System Software ↗

Regulatory guidance / GMP guideline · United States · February 2026

Scope: Medical-device manufacturers assuring software used in production or their quality management system.

Relevance: For medical-device production or QMS software, supports selecting assurance activities from intended use, risk and available evidence. It is nonbinding guidance and does not determine other sectors’ obligations.

Status: Final / published · Checked 2026-09-21

Publication identity, scope and status checked against the linked official source. This is not an independent audit of every retained guide statement.

Read source details and applicability →

EudraLex Volume 4, Annex 11 — Computerised Systems ↗

Regulatory guidance / GMP guideline · European Union · January 2011 revision

Scope: Computerised systems supporting activities in the applicable EU pharmaceutical GMP context.

Relevance: For computerised systems used in EU GMP activities, informs lifecycle, supplier and record controls. Confirm applicability to the actual activity; the example does not establish it.

Status: Final / published · Checked 2026-09-21

The Commission index confirms the January 2011 operative revision. The linked PDF could not be retrieved in this check; retained detailed section mappings need review against an authorized copy.

Read source details and applicability →

21 CFR Part 11 — Electronic Records; Electronic Signatures ↗

Regulation · United States · Current eCFR text

Scope: Electronic records and signatures within FDA Part 11 scope, tied to the underlying required records.

Relevance: Assess applicability to electronic records required by FDA predicate rules and electronic signatures used in their place. The presence of an electronic record alone is not an applicability conclusion.

Status: Final / published · Checked 2026-09-21

Publication identity, scope and status checked against the linked official source. This is not an independent audit of every retained guide statement.

Read source details and applicability →
Was this useful? Leave feedback

Was this resource useful?

Tell us what helped and what could be clearer. Usefulness feedback does not establish technical validity or regulatory compliance.

Loading contribution options…

Questions and moderated discussion

Questions and discussion

What additional information would you need before making this decision?

Loading contribution options…

Suggest a correction

Sent privately to the editorial moderation queue. Your account email and correction are not published as a comment. Do not include confidential or personal information.

Resource: Cloud migration: preserve a usable quality record

Loading sign-in status…

Correction details