Setting the file. One moment.
Subchapter 63.23
references/mysql-migrations/ddl-batching.mdMarkdown1 KBView on GitHub
Part of MySQL to DSQL DDL Migration. See Common Verify & Swap Pattern for the shared migration end-pattern.
REQUIRED for tables exceeding 3,000 rows.
See ddl-migrations/batched-migration.md for the full pattern including OFFSET-based batching, cursor-based batching, progress tracking, and error handling.
When migrating from MySQL, additional validation checks may be needed:
-- Find values exceeding target VARCHAR length
SELECT id, LENGTH(text_column) as len FROM target_table
WHERE LENGTH(text_column) > 255 LIMIT 100;