Solving Migration Pipelines
summary
Process-driven checklist: assess before plan with inventories of environments, scripts, CI/CD and BAU use counts; plan end-to-end including security, phased testing to BAU load and a post-migration audit. Solve change-data-capture explicitly: compare log-based vs query-based CDC, accept a small lag (seconds–minutes) and design for smart cutover or short offline window. For cloud choose among the six Rs (rehost/replatform/repurchase/retain/retire/refactor), use ETL or prebuilt pipelines, verify byte-level and order-preserving correctness.
AI-written summary · about
chapters (15)
- 0:00Migration pipelines intro
- 1:20What is a migration
- 2:27Migration types and challenges
- 3:33Solutions for migrations
- 4:15Assess current system
- 5:20Plan migrations end to end
- 6:45Security in migration planning
- 7:30Testing during migration
- 8:56Post-migration audits
- 9:40Change data capture
- 11:27Minimizing data loss
- 12:56Database migration key points
- 14:45Cloud migration aspects
- 15:49Six R strategies
- 17:14Conclusion and Q&A
related talks
16mHow to Prioritise Testing Activities to Reach Your Goals
31mHelp! My Database Is The Bottleneck
24mMigrations under Production Load: How to Switch...
01h 00mContinuous Integration and Delivery for Databases
22mData Integrity Tests in CI/CD Pipelines
50mMigrating data solutions to the cloud - a checklist.
39mRethinking RDBMS Data Migration
57mDe-risk Your Azure SQL Migration: 5 Critical Considerations