Database migrations with CockroachDB MOLT | Database Migration Demo

Description

In this presentation, Adam Storm, director of engineering, explains how to migrate databases using CockroachDB MOLT. The presentation also includes demos of a database migration using a schema migration tool and AWS DMS. Adam discusses four key items to consider in every migration, primary key choice, UUID, stored procedures, and the effects of geo-partitioning goals. The full slides from his presentation are available here: https://www.cockroachlabs.com/roachfest/deep-dive-simpler-migrations-with-cockroachdb-molt/ 00:00 Opening 01:00 Moving and Migrations 03:02: Journey to CockroachDB 04:16: Introducing CockroachDB Molt 04:54: Schema Conversion Tool 05:59: Demo: Schema Conversion Tool 15:40: Get started with the Schema Conversion Tool 16:02: Loading Data into CockroachDB 17:43: AWS DMS: Simple loading into CockroachDB 19:11: Step 1 create a replication instance 19:52: Step 2 Set up your source and target endpoints 20:24: Step 3 Create a migration task 20:55: Demo: AWS DMS 25:27: We are your partners in this journey #cockroachdb #DistributedDatabase #aws Link to database migration blog: https://www.cockroachlabs.com/blog/migrate-databases/ Database migration webinar: https://www.cockroachlabs.com/webinars/cockroachdb-molt/ Migration documentation: https://www.cockroachlabs.com/docs/cockroachcloud/migrations-page.html