概述
数据分批迁移工作流是一个中级难度的工作流。分批迁移大型数据集，最小化锁竞争并允许每阶段回滚。该工作流的目标是：Migrate data in controlled batches to minimize risk and enable partial rollback.
环境准备
执行本工作流需要以下环境：A source and target database；A migration script with batch processing；A rollback plan for each batch。请确保在开始前准备好所有必需的工具和资源，以避免中途因环境问题中断。
执行步骤
本工作流包含5个步骤。步骤1：Determine batch size——Calculate an appropriate batch size based on row size and lock timeout. 步骤2：Migrate first batch——Process the first batch of records and verify the results in the target. 步骤3：Validate data——Compare source and target data for the migrated batch to ensure correctness. 步骤4：Continue batches——Process subsequent batches, validating each before proceeding to the next. 步骤5：Final verification——Run a full count and sample comparison between source and target.
验证与清理
预期结果：All data is migrated in verifiable batches with the ability to roll back any individual batch.。验证方法：Compare row counts and sample data between source and target; confirm all batches are migrated correctly.。清理操作：Roll back the last batch if validation fails; fix the issue and reprocess that batch.。estimatedMinutes 为 120 分钟。
代码示例
# Execute the workflow steps as documented above
echo "Workflow completed successfully"