# Creating database migration assessment reports with DMS Schema Conversion An important part of DMS Schema Conversion is the report that it generates to help you convert your schema. This *database migration assessment report* summarizes all of the schema conversion tasks. It also details the action items for schema that can't be converted to the DB engine of your target DB instance. You can view the report in the AWS DMS console or save a copy of this report as a PDF or comma-separated value (CSV) files. The migration assessment report includes the following: + An executive summary + Recommendations, including conversion of server objects, backup suggestions, and linked server changes When you have items that DMS Schema Conversion can't convert automatically, the report provides estimates showing how much effort is required to write the equivalent code for your target DB instance. **Topics** + [Creating a database migration assessment report for DMS Schema Conversion](assessment-reports.create.md) + [Viewing your database migration assessment report for DMS Schema Conversion](assessment-reports-view.md) + [Saving your database migration assessment report for DMS Schema Conversion](assessment-reports-save.md) # Creating a database migration assessment report for DMS Schema Conversion After you create a migration project, use the following procedure to create a database migration assessment report. **To create a database migration assessment report** 1. Sign in to the AWS Management Console and open the AWS DMS console at [https://console.aws.amazon.com/dms/v2/](https://console.aws.amazon.com/dms/v2/). 1. Choose **Migration projects**. The **Migration projects** page opens. 1. Choose your migration project, and then choose **Schema conversion**. 1. Choose **Launch schema conversion**. The **Schema conversion** page opens. 1. In the source database pane, choose the database schema or schema items that you want to assess. To include multiple objects in the report, make sure that you select all items. 1. After you select the check boxes for all schema objects that you want to assess, you must choose the parent node for the selected objects. The **Actions** menu in the source database pane is now available. 1. Choose **Assess** in the **Actions** menu. A confirmation dialog box appears. 1. Choose **Assess** in the dialog box to confirm your choice. # Viewing your database migration assessment report for DMS Schema Conversion After you create an assessment report, DMS Schema Conversion adds information in the following tabs: + **Summary** + **Action items** The **Summary** tab shows the number of items that DMS Schema Conversion can automatically convert. The **Action items** tab shows items that DMS Schema Conversion can't convert automatically, and provides recommendations about how to manage these items. ## Assessment report summary The **Summary** tab displays the summary information from the database migration assessment report. It shows the number of items that DMS Schema Conversion can automatically convert for database storage objects and database code objects. In most cases, DMS Schema Conversion can't automatically convert all schema items to the target database engine. The **Summary** tab provides an estimate of the required effort to create schema items in your target DB instance that are equivalent to those in your source. To see the conversion summary for database storage objects such as tables, sequences, constraints, data types, and so on, choose **Database storage objects**. To see the conversion summary for database code objects such as procedures, functions, views, triggers, and so on, choose **Database code objects**. To change the scope of the assessment report, select the required node in the source database tree. DMS Schema Conversion updates the assessment report summary to match the selected scope. ## Assessment report action items The **Action items** tab contains a list of items that DMS Schema Conversion can't automatically convert to a format compatible with the target database engine. For each action item, DMS Schema Conversion provides the description of the issue and the recommended action. DMS Schema Conversion groups similar action items and displays the number of occurrences. To view the code for the related database object, select an action item in the list. ## Assessment report with generative AI DMS Schema Conversion with generative AI streamlines the database migration process by offering recommendations to help you convert previously unconverted code objects that typically require complex manual conversion. Currently, this feature is available for Oracle to PostgreSQL/Aurora PostgreSQL and SQL Server to PostgreSQL/Aurora PostgreSQL conversions. The assessment report which database code objects are candidates for conversion using generative AI. You can export this report to a PDF for a short list of five objects per action item. You can export the report to a CSV file to see the full list of candidates. When you enable **Convert schema using generative AI** and perform a conversion, the updated assessment report identifies the objects that converted successfully using AI. These objects are clearly marked with a corresponding action item, making it easy to identify and track the AI-generated conversion recommendations. To quickly locate objects that are converted by generative AI: 1. Navigate to the **Action Items** tab. 1. In the top-right corner, locate the drop-down menu. 1. Select **Generated by AI** from the options. This filtering method allows you to efficiently view all database objects that were successfully converted using this feature. # Saving your database migration assessment report for DMS Schema Conversion After you create a database migration assessment report, you can save a copy of this report as a PDF or comma-separated value (CSV) files. **To save a database migration assessment report as a PDF file** 1. Choose **Export**, then choose **PDF**. Review the dialog box, and choose **Export to PDF**. 1. DMS Schema Conversion creates an archive with your PDF file and stores this archive in your Amazon S3 bucket. To change the Amazon S3 bucket, edit the schema conversion settings in your instance profile. 1. Open the assessment report file in your Amazon S3 bucket. **To save a database migration assessment report as CSV files** 1. Choose **Export**, then choose **CSV**. Review the dialog box, and choose **Export to CSV**. 1. DMS Schema Conversion creates an archive with CSV files and stores this archive in your Amazon S3 bucket. To change the Amazon S3 bucket, edit the schema conversion settings in your instance profile. 1. Open the assessment report files in your Amazon S3 bucket. The PDF file contains both the summary and action item information. When you export your assessment report to CSV, DMS Schema Conversion creates three CSV files. The first CSV file contains the following information about action items: + Category + Occurrence + Action item + Subject + Group + Description + Documentation references + Recommended action + Line + Position + Source + Target + Server IP address and port + Database + Schema The second CSV file includes the `Action_Items_Summary` suffix in its name and contains the following information: + Schema + Action item + Number of occurrences + Learning curve efforts, which is the amount of effort required to design an approach to converting each action item + Efforts to convert an occurrence of the action item, which shows the effort required to convert each action item, following the designed approach + Action item description + Recommended action The values that indicate the level of required efforts are based on a weighted scale, ranging from low (least) to high (most). The third CSV file includes `Summary` in its name and contains the following information: + Category + Number of objects + Objects automatically converted + Objects with simple actions + Objects with medium-complexity actions + Objects with complex actions + Total lines of code