The migration overview provides a comprehensive snapshot of the various database objects and datatypes within migration. This tab acts as the landing page for any migration, located within the center of the screen, and is further split into two distinct sections, each offering different views and filtering options.
The left half of the Migration Overview displays all database object types, organized by their respective stages. This categorization helps with locate objects based on their functional role within the database:
- Structure
- Data (always empty, as the data stage only transfers table rows)
- Integrity
- Logic
- Not Migrated Automatically (objects that have no equivalent in PostgreSQL or are not supported yet)
Each row within the table displays the amount of the respective database object types, while specific entries can be expanded to reveal further details:
- Schemas: Displays counts for schemas with objects and those without.
- Indices: Lists the various types of indices present, including:
- Normal
- Unique
- Functional
- Domain
Clicking on any database object type sets a filter in the Sidebar (TODO: Link), focusing on relevant items associated with that selection. Furthermore, using Ctrl+Left Click adds or removes items from the filter, enabling multi-selection without losing the current filter context.
The right half of the Overview tab hosts a list of all present Data Types within the migration. This list is structured to allow for easy navigation and exploration:
- Expandable Data Types: Data types with various incarnations can be expanded to list each variation (e.g.,
number,number(8),number(10,2)). - Sorting Options: The list can be sorted alphabetically or by the quantity of each data type.
- Filtering: Clicking a specific data type automatically applies a filter within the Sidebar (TODO: Link), narrowing the view to items that correspond to columns with the chosen type.