# Using inventories for analysis in AWS DMS Fleet Advisor
**Important**
End of support notice: On May 20, 2026, AWS will end support for AWS Database Migration Service Fleet Advisor. After May 20, 2026, you will no longer be able to access the AWS DMS Fleet Advisor console or AWS DMS Fleet Advisor resources. For more information, see [AWS DMS Fleet Advisor end of support](https://docs.aws.amazon.com/dms/latest/userguide/dms_fleet.advisor-end-of-support.html).
To check the feasibility of potential database migrations, you can work with inventories of discovered databases and schemas. You can use the information in these inventories to understand which databases and schemas are good candidates for migration.
You can access database and schema inventories on the console. To do so, choose **Inventory** on the console.
![\[The Inventory tab of the DMS console.\]](http://docs.aws.amazon.com/dms/latest/userguide/images/datarep-console-nav-22.png)
DMS Fleet Advisor analyzes your database schemas to determine the similarity of different schemas. This analysis doesn't compare the actual code for objects. DMS Fleet Advisor compares only the names of schema objects, such as functions and procedures, to identify similar objects in different database schemas.
**Topics**
+ [
# Using a database inventory for analysis in AWS DMS
](fa-inventory-database.md)
+ [
# Using a schema inventory for analysis in AWS DMS
](fa-inventory-schema.md)
# Using a database inventory for analysis in AWS DMS
**Important**
End of support notice: On May 20, 2026, AWS will end support for AWS Database Migration Service Fleet Advisor. After May 20, 2026, you will no longer be able to access the AWS DMS Fleet Advisor console or AWS DMS Fleet Advisor resources. For more information, see [AWS DMS Fleet Advisor end of support](https://docs.aws.amazon.com/dms/latest/userguide/dms_fleet.advisor-end-of-support.html).
To view a list of all databases on all the discovered servers within your network from which data was collected, use the following procedure.
**To view a list of databases on your network servers that data was collected from**
1. Choose **Inventory** on the console.
The **Inventory** page opens.
1. Choose the **Databases** tab.
A list of discovered databases appears.
![\[Database inventory.\]](http://docs.aws.amazon.com/dms/latest/userguide/images/datarep-dmsstudio-inv-db.png)
1. Choose **Analyze inventories** to determine schema properties, such as similarity and complexity. The amount of time the process takes depends on the number of objects to analyze, but it won't take more than one hour. Results from the analysis are found on the **Schemas** tab located on the **Inventory** page.
DMS Fleet Advisor analyzes schemas across all discovered databases to define the intersection of their objects. The analysis result is expressed in percentage. DMS Fleet Advisor considers schemas with intersections of more than 50 percent as duplicates. Original schema is identified as the schema to which there are duplicates found. This helps to identify original schemas to convert or migrate first.
The entire inventory is analyzed together to identify duplicate schemas.
# Using a schema inventory for analysis in AWS DMS
**Important**
End of support notice: On May 20, 2026, AWS will end support for AWS Database Migration Service Fleet Advisor. After May 20, 2026, you will no longer be able to access the AWS DMS Fleet Advisor console or AWS DMS Fleet Advisor resources. For more information, see [AWS DMS Fleet Advisor end of support](https://docs.aws.amazon.com/dms/latest/userguide/dms_fleet.advisor-end-of-support.html).
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**
1. Choose **Inventory** on the console. The **Inventory** page opens.
1. Choose the **Schemas** tab. A list of schemas appears.
1. 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.
1. (Optional) Choose **Analyze inventories** to identify duplicate schemas. DMS Fleet Advisor analyzes database schemas to define the intersection of their objects.
1. You can export inventory information to a `.csv` file for further review.
![\[Schema Inventory.\]](http://docs.aws.amazon.com/dms/latest/userguide/images/datarep-dmsstudio-inv-schema.png)
To identify schemas to migrate and determine the migration target, you can use AWS Schema Conversion Tool (AWS SCT) or DMS Schema Conversion. For more information, see [Using a new project wizard in AWS SCT](https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP_UserInterface.html#CHAP_UserInterface.Wizard).
After you have identified schemas to migrate, you can convert schemas using AWS SCT or DMS Schema Conversion. For more information about DMS Schema Conversion, see [Converting database schemas using DMS Schema Conversion](CHAP_SchemaConversion.md).