All Products
Search
Document Center

Select a destination database

Last Updated: Feb 10, 2021

Purpose

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 tab. In the profile list, select a profile to be evaluated. Select Destination DB

  4. Click Next: Select Destination Database.

  5. 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.DB Object Compatibility

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

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

    Type Recommendation

    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