Migrate an OLTP database with minimal downtime
WHAT IT TESTS: near-zero-downtime data migration. OUTLINE: take an initial bulk load, then use change data capture to replicate ongoing changes until source and target are in sync, validate, then cut over during a brief window with a rollback plan.
WHAT IT TESTS: whether you can move a live transactional database with minimal downtime. ANSWER OUTLINE: bulk-load a consistent snapshot into the cloud target, then enable change data capture to stream every subsequent insert, update, and delete so the target continuously catches up to the source; validate row counts and checksums while both run; when replication lag is near zero, perform a short cutover that quiesces writes, drains the last changes, repoints the application, and verifies; keep the source as a rollback path.
Read the original → interview
- #database-migration
- #change-data-capture
- #zero-downtime
- #oltp
- #cloud
Get five bites like this every day.
Tezvyn delivers a daily feed of 60-second tech bites with quizzes to lock in what you learn.