AWS Schema Conversion Tool
User Guide (Version 1.0)

Creating Assessment Reports with AWS Schema Conversion Tool

An important part of the AWS Schema Conversion Tool is the database migration assessment report that it generates to help you convert your schema. The report summarizes all of the schema conversion tasks and 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 application. To do so, export it as a comma-separated value (CSV) or PDF file.

The migration assessment report includes the following:

  • Executive summary

  • License evaluation

  • Cloud support, indicating any features in the source database not available on the target.

  • Current source hardware configuration

  • Recommendations, including conversion of server objects, backup suggestions, and linked server changes

The report includes information about an Amazon RDS DB instance if you selected Amazon RDS as your target, including the following:

  • The currently used storage size and maximum storage size for the DB instance.

  • The current number of databases on the DB instance and the maximum number of databases allowed on the DB instance.

  • A list of database services and server objects that are not available on the DB instance.

  • A list of databases that are currently participating in replication. Amazon RDS doesn't support replication.

The report also includes estimates of the amount of effort that it will take to write the equivalent code for your target DB instance that can't be converted automatically. This Estimated Complexity field is exported in the PDF version of the assessment report, but it's not included in the CSV version.

If you use AWS SCT to migrate your existing schema to an Amazon RDS DB instance, the report can help you analyze requirements for moving to the AWS Cloud and for changing your license type.

You can find more details in the following topics: