Advanced Database & Application Migration (ADAM) provides multiple databases. You can use the suggestions provided in the ADAM console to analyze the compatibility of a source database with available destination databases. Then, you can select a suitable destination database for your business scenario.
Log on to the ADAM console.
In the left-side navigation pane, click Evaluate DB.
Click the Select Destination DB tab. In the profile list, select a profile to be evaluated.
Click Next: Select Destination Database.
On the Compatibility tab of the page that appears, you can view the DB object compatibility and SQL compatibility of the source database with the destination database.
The DB Object Compatibility table includes the compatibility, the number of compatible objects, and the number of incompatible objects.
Compatibility: The compatibility is equal to the number of compatible objects divided by the total number of objects.
Compatible with ADAM: the objects that are compatible with the destination database, and the objects that ADAM can transform. ADAM automatically converts incompatible objects to compatible objects.
Incompatible: the objects that are incompatible and must be manually transformed. ADAM provides comprehensive suggestions on how to transform these objects.
The SQL Compatibility table includes the compatibility, the number of compatible SQL statements, the number of incompatible SQL statements that can be converted, and the number of incompatible SQL statements.
Compatible After Conversion: ADAM provides SQL statements that can be executed in the destination database, but you must modify the corresponding SQL statements in the application.
ADAM allows you to obtain suggestions only on the database schemas that you want to migrate. You can select the schemas from the Select Schema drop-down list. This prevents the accuracy of suggestions from being affected due to database schemas that you do not want to migrate.
On the Type Recommendation tab, you can view the recommended destination database. ADAM provides suggestions on appropriate destination databases based on the profile and scenarios of the source database, and the compatibility of the source database with available destination databases. The scenarios include transactional processing (TP), analytical processing (AP), hybrid transaction/analytical processing (HTAP), and tests.Notice
The recommended destination databases vary with collected data and are for reference only.
Estimated source database type
Small or test databases
Databases for online transactional processing
Databases for online analytical processing
Databases for hybrid transaction/analytical processing