Using a schema inventory for analysis - Amazon Database Migration Service
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Using a schema inventory for analysis

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.

  2. Choose the Schemas tab. A list of schemas appears.

  3. 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.

  4. (Optional) Choose Analyze inventories to identify duplicate schemas. DMS Fleet Advisor analyzes database schemas to define the intersection of their objects. DMS Fleet Advisor considers schemas with intersections of more than 50 percent as duplicates. You can see detailed analysis results in the columns Similarity and Original schema on the Schemas tab of the Inventory page.

  5. You can export inventory information to a .csv file for further review.

Schema Inventory.

To identify schemas to migrate and determine the migration target, you can use Amazon Schema Conversion Tool (Amazon SCT). 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.