Discovering and evaluating databases for migration with Amazon DMS Fleet Advisor

You can use DMS Fleet Advisor to collect metadata and performance metrics from multiple database environments. These collected metrics provide insight into your data infrastructure. DMS Fleet Advisor collects metadata and metrics from your on-premises database and analytic servers from one or more central locations without the need to install it on every computer. Currently, DMS Fleet Advisor supports discovery and metrics collection for Microsoft SQL Server, MySQL, Oracle, and PostgreSQL database servers.

Based on data discovered from the network, you can build an inventory to define the list of database servers for further data collection. After Amazon DMS collects information about your servers, databases, and schemas, you can analyze the feasibility of your intended database migrations.

For databases in your inventory that you plan to migrate to the Amazon Web Services Cloud, DMS Fleet Advisor generates right-sized target recommendations. To generate target recommendations, DMS Fleet Advisor considers the metrics from your data collector and preferred settings. After DMS Fleet Advisor generates recommendations, you can view detailed information for each target database configuration. Your organization's database engineers and administrators can use DMS Fleet Advisor Target Recommendations to plan the migration of their on-premises databases to Amazon. You can explore different available migration options and export these recommendations into the Amazon Pricing Calculator to further optimize the cost.

For the list of supported source databases, see Sources for DMS Fleet Advisor.

For the list of databases that DMS Fleet Advisor uses to generate target recommendations, see Targets for DMS Fleet Advisor. DMS Fleet Advisor generates like to like recommedations, for example, from source Oracle to target Oracle database. DMS Fleet Advisor also generates heterogenous recommendations, such as migration from source Oracle or Microsoft SQL Server to target RDS for PostgreSQL or Aurora PostgreSQL database.

The following diagram illustrates the Amazon DMS Fleet Advisor Target Recommendations process.

Use the following topics to better understand how to use Amazon DMS Fleet Advisor.

Supported Amazon Web Services Regions

You can use DMS Fleet Advisor in the following Amazon Web Services Regions.