Conversion assessment reports with DMS Schema Conversion

source-server/target-host/target-host.csv — one row per action item occurrence.

source-server/target-host/target-host_Action_Items_Summary.csv — one row per action item type, with effort values.

source-server/target-host/target-host_Summary.csv — one row per object type, with complexity counts.

source-server/target-host/target-host_Stub_Objects.csv — one row per stub object generated for an unsupported built-in. This file is present only when Convert unsupported built-in objects to stub objects is enabled in your migration project settings.

Summary

Action items

Executive summary — An overview of the migration complexity. Shows the number of database objects that DMS Schema Conversion can convert automatically and the number that require manual action, broken down by object type (tables, views, procedures, triggers, and so on) and by complexity category (automatically converted, simple actions, medium-complexity actions, and complex actions). For more information about these categories, see Complexity categories.

Database objects with conversion actions — A breakdown of which specific database objects require manual action, organized by object type. Each entry identifies the object by name and lists its action item code.

Candidates for conversion with generative AI — The database objects that DMS Schema Conversion identifies as candidates for automated conversion using generative AI. The PDF lists up to five candidate objects per action item type. To see the complete list of candidates, export the report as CSV.

Detailed recommendations for migrations — A per-object analysis of every database object that requires manual action. For each object, this chapter shows the action item code (see Action item codes), a description of the specific incompatibility with the target database engine, and the recommended manual conversion action. Unlike the Action items tab in the AWS Management Console, which groups action items by type across all objects, this chapter lists each affected object individually.

Category — The type of database object that the action item applies to, such as procedure or view-constraint.

Occurrence — The fully qualified path to the specific database object instance that the action item affects, such as Schemas.schema_name.Procedures.procedure_name.

Action item — The numeric action item code that identifies the type of conversion issue. For more information, see Action item codes.

Subject — The specific database object name or code element that the action item refers to, such as an unresolved identifier. This field is empty when the action item does not reference a specific object name.

Group — A generic description of the issue type shared by every occurrence of that action item code. DMS Schema Conversion uses this value to group related occurrences together.

Description — A detailed description of the specific incompatibility for this occurrence.

Documentation references — Links to relevant documentation for resolving the incompatibility.

Recommended action — The suggested manual conversion step to resolve the incompatibility.

Filtered — Indicates whether the action item was filtered out of the report view.

Estimated complexity — The complexity category assigned to this occurrence: automatically converted, simple actions, medium-complexity actions, or complex actions.

Line — The line number in the source object's code where the incompatibility occurs.

Position — The character position on the line where the incompatibility occurs.

Source — The source database engine.

Target — The target database engine.

Server IP address and port — The host and port of the source database server.

Database name — The name of the source database.

Schema name — The name of the source schema containing the affected object.

AI/ML Recommendation — The generative AI recommendation for converting this object, when generative AI conversion was enabled and produced a result for this occurrence.

Schema — The name of the source schema containing the affected objects.

Action item — The numeric action item code that identifies the type of conversion issue. For more information, see Action item codes.

Number of occurrences — The total number of database objects affected by this action item type.

Learning curve efforts — The one-time effort required to design a conversion approach for this action item type. You incur this cost once per action item type regardless of the number of occurrences. Values use a weighted scale ranging from low (least effort) to high (most effort).

Efforts to convert an occurrence — The effort required to resolve each individual occurrence of this action item type, following the designed conversion approach. Values use the same weighted scale as learning curve efforts.

Action item description — A description of the incompatibility that this action item type represents.

Recommended action — The suggested manual conversion step to resolve this action item type.

Category — The database object type that the row summarizes, such as TABLE, VIEW, PROCEDURE, TRIGGER, INDEX, CONSTRAINT, SEQUENCE, or FUNCTION. The file also includes aggregate metric rows with a Category value of Storage_objects_count, Code_objects_count, or SQL_syntax_elements_number. For more information about these aggregate values, see Conversion statistics and SQL metrics.

Number of objects — The total number of database objects of this type in the assessed scope.

Objects automatically converted — The number of objects that DMS Schema Conversion can convert without any manual action.

Objects with simple actions — The number of objects that require a small amount of manual effort to convert.

Objects with medium-complexity actions — The number of objects that require a moderate amount of manual effort to convert.

Objects with complex actions — The number of objects that require significant manual effort to convert.

Total lines of code — The total number of lines of source code across all objects of this type.

Category — The type of the stub object, such as scalar-function.

Stub object name — The fully qualified name of the generated stub, including schema and signature.

Number of occurrences — The number of times this stub object is referenced in the converted code.