data-migration-best-practices
Operational data migration guidance. Use when moving or transforming persisted data between schemas, databases, services, or storage technologies; running large backfills; applying expand-and-contract schema changes; combining snapshots with live CDC/events; designing resumable batches and checkpoints; reconciling source and target; or planning cutover, rollback, and repair.
Target: Target not categorized. Automatically collected · unverified.
Excerpt from the author’s documentation
Extracted from a fixed version of SKILL.md in its original language. This is the author’s documentation; installation, compatibility and runtime results have not been verified by this site.
Read the original English text
Topics in the source
- Data Migration Best Practices
- Workflow
- Decision Rules
- Safety Invariants
- Gates
- Related Skills
- Reference
Treat migration as a temporary production system with explicit correctness, capacity, observability, and retirement criteria. It changes persisted behavior and is not automatically a refactoring. 1. Define source authority, target contract, transformations, invariants, data classification, and tolerated downtime/staleness. 2. Choose a stable snapshot boundary or high-water mark and start durable capture of live changes before they can escape the snapshot. 3. Expand the target schema compatibly; keep old and new application versions interoperable during rolling deployment. 4. Backfill in bounded, idempotent, resumable batches with deterministic progress and explicit bad-row handling. 5. Apply captured deltas without allowing stale snapshot data to overwrite newer writes. 6. Reconcile availability, counts, identities, values, and domain invariants against a declared watermark. 7. Cut over only when freshness and discrepancy gates pass; monitor and retain a reversal or forward-repair path. 8. Contract old fields, code paths, capture infrastructure, and temporary permissions only after an observation window. Prefer direct transactional SQL for small same-database transformations that f
This is an excerpt. Refer to the complete source and its current requirements.
- Source repository
- OKHP3/skillz
- Source file
- docs/archive/skill-redundancy-2026-09-19/docs-data/originals/community/data-migration-best-practices/SKILL.md
- Fixed revision
- 7b187777d42ab7bc7bab1e5f2c940cd3139ecebf
Sources and evidence
This record was collected automatically. Its documentation, suitability and runtime behavior have not been manually verified.
Author: OKHP3/skillz · original repository metadata. Documentation review: Not reviewed. Last source check: 2026-11-10T10:00:54.866Z.
Categories are inferred from names, descriptions and paths. They do not establish compatibility.
License and attribution
MIT. Third-party content and copyright remain with their authors. Refer to the original license and terms.
Original license ↗Synchronization, copying and user-reported success do not mark a resource as runtime-tested.
Limitations and notes
- Collecting metadata does not mean this site has installed, adapted, runtime-tested or security-reviewed the resource.