The Stages tab serves as the control center for managing migration jobs within the migration. It allows for starting, stopping, and configuring migration processes, with real-time feedback on the progress and status of individual stages and tables.
At the top of the Stages tab, a button group offers the primary controls for migration jobs:
- Start Button: Initiates a new migration job. This button can be expanded to reveal additional options:
- Start: Starts the migration from the beginning, erasing all previous work on the target database.
- Resume: Resume a previously failed migration job from where it encountered an error.
- Rerun: Restarts the entire stage, erasing any work done on the target database as part of the stage.
- Continue: Resume the migration from the next stage, skipping any pending or erroneous work that would have happened in the current stage.
- Stop Button: This button becomes available only when a migration job is active. Pressing it aborts the current migration job, halting all progress.
- Options Button: This button opens a context menu with two toggle options:
- Abort Stage on First Error: Stops the migration job as soon as an error occurs.
- Pause After Each Stage: Pauses the migration at the end of each stage, awaiting the user to start a new migration job.
To the right of the control menu, the migration stages are displayed in sequence: structure, data, integrity, and logic. Each stage visually indicates its status through border styles and colors:
- Grey Dashed Border: Indicates that the stage has not yet started or has been skipped.
- Blue Spinner: Signifies an active stage that is currently running.
- Green Border: Shows that the stage has completed successfully.
- Red Border: Indicates that the stage has failed.
- Yellow Border: Represents a stage that was aborted.
Hovering over a stage reveals additional options:
- Stage Hooks: Appear to the left and right of each stage when hovered over. Pressing these icons allows the configuration of stage hooks.
- Data Stage Settings: Hovering over the Data stage reveals a settings icon. Selecting it opens a menu with two options:
- Skip: A toggle button that, when enabled, causes the Data stage to be skipped in migration jobs.
- SCN: A text field where an SCN (System Change Number) can be manually entered, allowing for precise control over data migration specifics.
Below the stages and control menu, a progress bar and a table provide additional insights into the data stage:
- Progress Bar: Displays the current state of tables during migration, categorized into five states: Pending, Running, Aborted, Failed, and Successful.
- Tables Overview: This table lists all tables alphabetically as they are processed during the data stage. The status of each table is displayed on the right-hand side. Tables with partitions or those utilizing chunking can be expanded by clicking the small arrow on the left, which reveals partition or chunk-specific statuses.
