Target database selection suggestions

Procedure

1. Log on to DMS 5.0.

2. In the top navigation bar, choose Data + AI > Advanced Database & Application Migration (ADAM) > Database assessment.

3. Click the Source database profiling analysis tab.

4. On the Source database profile tab, select a source database profile and click Next: View Target Database Selection Suggestions.

5. On the Target database selection suggestions tab, click the Compatibility tab to view your source database's compatibility with various target database versions.

   • Database object compatibility:

     • Compatibility: The percentage of objects that are compatible with ADAM, including those automatically converted.

     • Compatible: Objects that are directly compatible with the target database or can be automatically converted by ADAM. The ADAM database transformation feature can then automatically create these objects in the target database.

     • Incompatible: Objects that require manual modification. ADAM provides modification suggestions.

   • SQL compatibility:

     • Compatibility: The percentage of objects that are already compatible or become compatible after modification.

     • Compatible: Objects that are directly compatible with the target database or can be automatically converted by ADAM.

     • Compatible after modification: Objects that become compatible after you modify your application's SQL statements.

     • Incompatible: Objects that cannot be made compatible.

   Note

   To assess only specific schemas, use the Schema filter drop-down list in the upper-left corner of the Compatibility tab. This prevents schemas that you are not migrating from affecting the assessment's accuracy.

6. Click the Type recommendation tab to view ADAM's recommended target databases.

   ADAM analyzes your source database's use case and compatibility data to recommend the most suitable target database.

   Important

   The estimated database type is based on the collected data and is for reference only.

   Estimated type	Description
   SAMPLE	A small-scale or test database.
   OLTP	An online transaction processing (OLTP) database.
   OLAP	An online analytical processing (OLAP) database.
   HTAP	A hybrid transactional/analytical processing (HTAP) database.

Next steps

At the bottom of the target database selection suggestions tab, click Next: Create database assessment to create a database assessment project. For more information, see Database assessment and analysis.