The Assessment tab provides a detailed analysis of the effort required for database migration. This section is designed to help identify the most complex database objects and prioritize resource allocation based on migration complexity.
At the top of the Assessment tab, three summary boxes provide key metrics related to the migration:
- Migration Level: This metric combines a letter (A, B, or C) and a digit (1 to 5) to convey the overall difficulty of the migration.
- A: Indicates that the migration might be run automatically, with minimal or no manual intervention
- B: Requires some code rewriting, typically with an estimated effort up to 5 person-days.
- C: Involves significant code rewriting, with an estimated effort exceeding 5 person-days.
- 1 (Trivial): Contains no stored functions or triggers, indicating minimal effort.
- 2 (Easy): Involves triggers but no stored functions, with no manual rewriting required.
- 3 (Simple): Includes stored functions or triggers, without the need for manual rewriting.
- 4 (Moderate): Triggers or views that require code rewriting but do not involve stored functions.
- 5 (Difficult): Contains stored functions or triggers, requiring manual code rewriting.
- Objects: Displays the total number of database objects that are included in the migration.
- Migration Effort: An abstract value calculated by the Migrator, which indicates the relative complexity or “cost” associated with migrating each database object. This metric does not correlate directly with time or expense but serves to highlight objects requiring more effort.
An interactive chart categorizes migration effort by object type, helping in identifying resource-intensive areas:
- Grouping by Object Type: Database objects are grouped by type (e.g., tables, triggers, functions), showing the total effort associated with each category.
- Drill-Down: Clicking on a specific object type expands the view to show all objects in that category.
- Zoom: Narrow the number of objects shown in the chart.
- Average Effort Line: A horizontal line represents the average migration effort.
Below the chart, a sortable and filterable table lists all database objects based on their calculated effort, providing control over the assessment details:
- Sorting/Filtering: Allows sorting or filtering of database objects by various criteria.
- Object Link: Each row includes a button that links to the editor for the respective database object, allowing for quick access for review or modification.
- Effort Details: Selecting an object updates the information component on the right, providing a detailed breakdown of the factors contributing to the migration effort calculation for that specific object.
