All Products
Search
Document Center

Select a destination database

Last Updated: Nov 04, 2021

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.

Procedure

  1. Log on to the ADAM console.

  2. In the left-side navigation pane, click Evaluate DB.

  3. Click the Select Destination DB step. In the profile list, select a profile to be evaluated.

  4. Click Next: Select Destination Database.

  5. On the Compatibility tab of the page that appears, you can view the object compatibility and SQL compatibility between the source database and 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.

      • Compatibility: The compatibility is equal to the total number of compatible SQL statements and SQL statements that need to be modified divided by the total number of objects.

      • Compatible: the number of objects that are directly compatible or compatible after transformation.

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

      • Incompatible: incompatible objects.

  6. 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 by database schemas that you do not want to migrate.

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

    Description

    SAMPLE

    Small or test databases

    OLTP

    Databases for online transactional processing

    OLAP

    Databases for online analytical processing

    HTAP

    Databases for hybrid transaction/analytical processing