Advanced Database & Application Migration (ADAM) helps you migrate Oracle databases to the cloud by covering the full migration lifecycle—from pre-migration evaluation through schema transformation to final migration. ADAM analyzes your source database, recommends a destination database, estimates the workload and cost, and automates schema transformation to reduce migration risk and complexity. ADAM includes built-in tools for implementation assistance, data migration, and application migration.
ADAM is free to use.
Supported sources and destinations
ADAM supports Oracle as the source database.
| Source database | Supported versions |
|---|---|
| Oracle | 10g, 11g, 12c, 18c, 19c |
To see which destination databases ADAM recommends for your Oracle version, run a database evaluation. ADAM analyzes your source database and suggests compatible destination databases based on object and SQL compatibility.
Use cases
Migrating traditional IT systems to the cloud
Traditional on-premises systems often rely on an IOE (IBM, Oracle, EMC) minicomputer architecture, which scales only through hardware upgrades. Performance gains from those upgrades are not proportional to cost, making linear scaling impractical. An internet-based distributed architecture scales horizontally, with performance gains proportional to hardware investment. ADAM provides the toolchain and best practices to move from an IOE architecture to a cloud-native distributed architecture.
Expanding or replacing a database already on Alibaba Cloud
If your system is already on Alibaba Cloud but your existing database no longer meets business demands, ADAM helps you select a destination database and transform your applications to support the new database.
Features
Collectors
The Database Collector collects and summarizes source database information across six dimensions: environment, objects, SQL, space, performance, and transactions. It masks sensitive data, removes duplicates, and runs consistency checks on SQL data to prevent data leaks and ensure accuracy.
For more information, see Database Information Collection.
Database evaluation
ADAM evaluates your source database and recommends a destination database. The evaluation covers three areas:
Source database profile analysis: Analyzes collected data across multiple dimensions—performance, capacity, features, external dependencies, object details, and panoramic search. The panoramic analysis maps object relationships and identifies feature identifiers.
Destination database recommendation: Compares object and SQL compatibility between your source database and candidate destination databases, then recommends the best fit based on your usage scenarios.
Destination database compatibility evaluation: For a specific destination database version, provides the degree of object and SQL compatibility, a list of object transformation points, a recommended minimum specification, estimated costs, and migration threat warnings.
For more information, see Database Evaluation Overview.
Database transformation and migration
ADAM migrates the source database schema to the destination database. Incompatible DDL statements are handled through a combination of intelligent automatic transformation and manual correction where needed.
For more information, see Online Transformation and Migration Overview.
Manage database archives
Create, test, and delete database archives in ADAM so you don't have to re-enter database connection information each time you use a feature.
For more information, see Manage Database Archives.
Benefits
Internal migration experience at scale: ADAM is built on years of successful internal migration experience at Alibaba, including a full toolchain and best practices for moving from traditional IOE architectures to cloud-native distributed architectures.
Pre-migration cost and workload visibility: Before migration begins, ADAM evaluates feasibility, estimates the migration workload and cost, and recommends destination storage options—so you can plan and budget with confidence.
Sensitive data protection: The Database Collector masks collected data to prevent leaks of sensitive database information.
Compatibility analysis:
Source feature matching: Identifies which database features your objects use and provides corresponding solutions for the destination database.
Source scenario matching: Evaluates whether the destination database can effectively support specific usage scenarios that may affect performance. If adjustments are needed, ADAM provides an adjustment plan.
Automatic schema transformation: ADAM automatically converts supported source database objects—tables and other schema objects—into corresponding objects or Java code in the destination database, including automatic creation of table schemas.