Migrating to CockroachDB | AI Migration Assistant

Description

Rob Reid demonstrates how to use the AI Migration Assistant, part of the MOLT suite of tools, to migrate a PostgreSQL database into CockroachDB. He guides viewers through the step-by-step process, starting by creating a CockroachDB cluster target and connecting both source and target databases. The assistant extracts the schema, tokenizes sensitive data to protect privacy during LLM processing, converts schema syntaxes, and generates an automated migration plan. After creating the target database structure and copying over eight tables consisting of roughly 2 million rows, the tool helps convert, rewrite, test, and compare user-defined functions across both databases. Finally, foreign key constraints are restored, and the data is validated using MOLT Verify to ensure complete consistency, concluding a successful migration. Learn more at cockroachlabs.com