Data Transmission Service:Select a destination database

Procedure

1. Log on to the Data Management (DMS) console V5.0.

2. In the top navigation bar, move the pointer over DTS. Choose Heterogeneous Database Migration(ADAM) > Database Evaluation.

3. Click the Source DB Profile Select Destination DB tab.

4. In the Source DB Profile step, select the database profile that you want to evaluate and click Next: Select Destination Database.

5. In the Select Destination DB step, click the Compatibility tab to view the compatibility between the source database and different versions of destination databases.

   • DB Object Compatibility

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

   • SQL compatibility

     • Compatibility: The compatibility is equal to the total number of directly compatible SQL statements and SQL statements that are compatible after transformation 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.

   Note

   If you want to migrate only specific schemas, you can click Select Schema in the upper-left corner of the Compatibility tab. In the drop-down list, you can select the schemas that you want to migrate. This way, you can filter out schemas that you do not want to migrate and improve the accuracy of the destination database recommendations.

6. On the Type Recommendation tab, you can 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. This way, ADAM recommends the most suitable destination database for you.

   Notice

   The 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 to do next

In the Select Destination DB step, click Next: Create Destination DB Evaluation Project to create an evaluation project. For more information, see Evaluate a database.