Advanced Database & Application Migration (ADAM) analyzes your source database's compatibility against available destination databases and recommends the most suitable destination database for your workload.
Prerequisites
Before you begin, make sure that you have:
-
Access to the Data Management (DMS) console V5.0
-
A database profile created in ADAM (from the Source DB Profile step)
Select a destination database
-
Log on to the Data Management (DMS) console V5.0.
-
In the top navigation bar, move the pointer over Data + AI. Choose Heterogeneous Database Migration(ADAM) > Database Evaluation.
-
Click the Source DB Profile Select Destination DB tab.
-
In the Source DB Profile step, select the database profile to evaluate, then click Next: Select Destination Database.
-
On the Compatibility tab, review how your source database maps to each destination database version. The tab shows two compatibility dimensions:
NoteTo focus the analysis on specific schemas, click Select Schema in the upper-left corner of the Compatibility tab and select the schemas to include. Filtering out irrelevant schemas improves the accuracy of the destination database recommendation.
DB Object Compatibility
Metric Description Compatibility Compatible objects / total objects. Use this score to compare destination database versions. Compatible with ADAM Objects that are directly compatible with the destination database, plus objects that ADAM transforms automatically. Incompatible Objects that require manual transformation. ADAM provides comprehensive suggestions on how to transform these objects. SQL compatibility
Metric Description Compatibility (Directly compatible SQL + SQL compatible after transformation) / total objects Compatible SQL statements that are directly compatible or compatible after transformation Compatible After Conversion ADAM provides equivalent SQL for the destination database. You must update the corresponding SQL in your application code. Incompatible Incompatible SQL statements. -
Click the Type Recommendation tab to view the recommended destination database. Based on the data profile that you select, ADAM intelligently analyzes the scenarios in which the source database is used and the compatibility of the source database with different types of destination databases, then recommends the destination database best suited to your workload:
ImportantThe recommended database varies based on the collected data. The recommendation is only for your reference.
Estimated source database type Description SAMPLE Small or test databases OLTP Databases for online transactional processing OLAP Databases for online analytical processing HTAP Databases for hybrid transaction and analytical processing
What's next
Click Next: Create Destination DB Evaluation Project to create an evaluation project for the selected destination database. For more information, see Evaluate a database.