Using a schema inventory for analysis in Amazon DMS
Important
End of support notice: On May 20, 2026, Amazon will end support for Amazon Database Migration Service Fleet Advisor. After May 20, 2026, you will no longer be able to access the Amazon DMS Fleet Advisor console or Amazon DMS Fleet Advisor resources. For more information, see Amazon DMS Fleet Advisor end of support.
You can view a list of database schemas discovered on servers within your network from which the data was collected. Perform the following procedure.
To view a list of schemas on your network servers that data was collected from
-
Choose Inventory on the console. The Inventory page opens.
-
Choose the Schemas tab. A list of schemas appears.
-
Select a schema in the list to view information about it, including server, database, size, and complexity.
For each schema, you can view an object summary that provides information about object types, number of objects, object size, and lines of code.
-
(Optional) Choose Analyze inventories to identify duplicate schemas. DMS Fleet Advisor analyzes database schemas to define the intersection of their objects.
-
You can export inventory information to a
.csv
file for further review.

To identify schemas to migrate and determine the migration target, you can use Amazon Schema Conversion Tool (Amazon SCT) or DMS Schema Conversion. For more information, see Using a new project wizard in Amazon SCT.
After you have identified schemas to migrate, you can convert schemas using Amazon SCT or DMS Schema Conversion. For more information about DMS Schema Conversion, see Converting database schemas using DMS Schema Conversion.