A database compatibility assessment helps you evaluate the compatibility, specifications, and migration risks of a target database to understand the feasibility of your cloud migration and the required transformation workload.
Create a target database assessment project
On the Destination Database Selection Suggestions tab, click Next: Create Target Database Assessment to create a new assessment project, or follow the steps below.
Log on to Data Management DMS 5.0.
In the top navigation bar, choose .
Click the Target Database Compatibility Assessment tab.
Click Create Project.
In the Create Project panel, configure the parameters for the target database assessment project.
Parameter
Description
Project name
Enter a name for the target database assessment project. This name helps you identify the project in future database transformation and migration tasks.
Source database profile
Select the source database profile to assess.
Project type
Select the target database type.
Target database version
Select the target database version.
Assess invalid objects
Select whether to assess invalid objects in the source database profile:
Yes: Assess invalid objects.
No: Ignore invalid objects during the assessment.
NoteInvalid objects are objects such as packages, procedures, functions, and views that become INVALID during routine source database maintenance or data migration.
Kernel version
If the target database is PolarDB for Oracle, you must select a kernel version.
Report language
Select the language for the assessment report:
Chinese
English
Schema filter
Select the schema types to assess:
In the Unselected list on the left, select the schema types you want to assess.
Click the
icon to move the selected schema types to the Selected list on the right.
Click Create.
After you create the project, the system automatically starts the target database assessment and generates an analysis report.
View project assessment results
Log on to Data Management DMS 5.0.
In the top navigation bar, choose .
Click the Target Database Compatibility Assessment tab.
In the Actions column for the target project, click Details.
NoteThe project status must be Complete, which indicates that the target database assessment and analysis are finished.
On the project assessment details page, view the assessment results.
Project Overview:
This section lists basic information about the assessment project: Project Name, Source Database Profile, Source Database Type, Project Type, and Target Database Version.
Assessment Summary:
Compatibility: Includes object compatibility and SQL compatibility. This measures the compatibility between the source and target databases. A higher compatibility score means fewer objects and SQL statements require modification.
Transformation: The number of transformation points that require modification to migrate to the target database.
Object transformation points: Advanced Database & Application Migration (ADAM) can automatically transform these points without manual intervention.
Application transformation points: These are identified by analyzing the SQL statements collected from the database and provide a preliminary assessment for the database migration.
Specifications: Based on the collected data, ADAM intelligently calculates the required database specifications and estimated costs for migrating to the target database. The collection environment influences the specification assessment. The actual purchase decision should be made based on a comprehensive evaluation of your business needs.
Risk: Provides risk warnings for migration and transformation. This includes existing risks in the source database and potential risks that may arise after migrating to the target database.
Overall Compatibility: Shows the compatibility of objects and SQL after migrating from the source to the target database.
Assessment Details: In the Assessment Details area, click Details next to each assessment item to view the results. For more information, see Assessment details.
Optional: Download the project assessment report.
You can click Download Abridged Report, Download All Reports, or Download HTML Report to download the respective reports as needed.
Assessment details
Object compatibility
The Schema Compatibility panel lists the compatibility assessment results for all objects. All object types from the source database are included and categorized as compatible or incompatible.
Click Details in the Actions column for an object compatibility item to view details such as the number of compatible and incompatible objects and information about incompatibility rules in the Schema Compatibility panel.
For objects that are compatible after modification, ADAM provides the transformed DDL and the transformation points. For incompatible objects, ADAM provides the reason for incompatibility and an error message, which you can use to modify the DDL.
SQL compatibility
SQL compatibility is assessed by performing a syntax analysis on the SQL statements collected from the database.
Click the Assessment Overview tab to view overall compatibility statistics, including compatible, incompatible, and compatible after modification.
Click the Assessment Details tab to view object compatibility details, including compatibility status, source SQL, and target SQL.
Click View under Source SQL to view the details of the source SQL.
Click View under Target SQL to view the details of the target SQL. Click the Error message or Change Message tab to view the reason for incompatibility or information about the changes.
For database SQL, the ADAM database assessment analyzes compatibility based on the executed SQL statements recorded by the database. You must determine whether the SQL comes from real business traffic or use ADAM application assessment for further analysis.
Click the Rule Details tab to view the details of the compatibility rules.
Object transformation points
This section provides a summary of transformation points for database objects, which can be used to perform manual transformations.
Transformation Level: All objects are graded to indicate the complexity of each transformation point. This helps your team plan and assign transformation tasks. A higher transformation level indicates greater complexity.
Source DDL: Click View under this column to view the source DDL code.
Target DDL: Click View under this column to view the target DDL code.
Transformation Point: Click Database under this column to view the transformation point ID, detailed transformation methods, and other information.
Target database specifications
Target database specifications provide guidance on specifications and migration plans for migrating to Alibaba Cloud databases.
The recommended specifications are calculated based on a comprehensive analysis of the source database's configuration, performance, SQL, and external dependencies, as well as the target database. This serves as a valuable reference for purchasing decisions during migration.
On the Target Database Solution tab, click Details next to an object ID to view detailed information about the objects in each migration group.
On the Cross-database Objects tab, view the Details of cross-database objects. For target solutions that involve multiple migration instances, cross-database objects may exist.
Migration risks
Migration risks include source database risks and target database risks.
Source database risks are SQL statements collected from the source database that consumed high CPU or memory during execution. They are categorized into types such as TOP CPU and TOP Buffer. Pay close attention to these SQL statements during testing.
Target database risks refer to potential issues that can arise when you execute transformed database structures or SQL statements in the target database. Pay close attention to these risks to avoid performance differences caused by heterogeneous database migration.
Project external dependencies (schema)
This section assesses the number of externally dependent objects and provides solutions.
Next steps
At the bottom of the Target Database Compatibility Assessment tab, click Start Database Transformation to begin the database transformation and migration process. For detailed instructions, see database transformation and migration.