ZDM / DMS Comparison
This article shows a detailed feature comparison between Zero Downtime Migration (ZDM) and OCI Database Migration (DMS).
Please always check the latest documentation updates for any changes.
General Overview
General overview and high level feature comparison between the 2 migration tools.
Zero Downtime Migration (ZDM)
- User managed software (Installation, Patching, Job Management, ...)
- Physical offline and online migrations
- Logical offline and online migrations
- No graphical user interface
- Cloud Premigration Advisor Tool (CPAT) integration
- Supports for On-Premises Targets (Exadata Cloud@Customer, Exadata On-Premises)
- Fleet Migrations
- Customizing migration jobs (User Action Scripts)
- Free 1
OCI Database Migration (DMS)
- Fully managed cloud service based on ZDM
- Logical offline and online migrations
- Graphical guidance
- Integrated GoldenGate
- MySQL migration support
- Cloud Premigration Advisor Tool (CPAT) integration - Interactive CPAT Report
- Free 2
Migration Methods
Overview of the different supported migration methods:
| Migration Method | ZDM | DMS |
|---|---|---|
| Physical Offline (RMAN) | ✅ | ❌ |
| Physical Online (RMAN + Data Guard) | ✅ | ❌ |
| Logical Offline (Data Pump) | ✅ | ✅ |
| Logical Online (Data Pump + GoldenGate) | ✅ | ✅ |
Supported Source DB Versions
Overview of the supported source database versions:
| Source DB Version | ZDM | DMS |
|---|---|---|
| 21c | ✅ | ✅ |
| 19c | ✅ | ✅ |
| 18c | ✅ | ✅ |
| 12.2 | ✅ | ✅ |
| 12.1 | ✅ | ✅ |
| 11.2.0.4 | ✅ | ✅ |
| < 11.2.0.4 | ❌ | ❌ |
Supported Source Platforms
Overview of the supported source platforms:
| Source Platform | ZDM | DMS |
|---|---|---|
| Linux x86 | ✅ | ✅ |
| Solaris Sparc | ✅ | ✅ |
| AIX Power | ✅ | ✅ |
| Windows | ❌ | ❌ |
| AWS RDS Oracle Database | ✅ | ✅ |
Supported Target Platforms
Overview of the supported target platforms:
| Target Platform | ZDM | DMS |
|---|---|---|
| Autonomous DB Serverless | ✅ | ✅ |
| Autonomous DB Dedicated | ✅ | ✅ |
| Base Database Service (DBCS) | ✅ | ✅ |
| Exadata Cloud Service | ✅ | ✅ |
| Exadata Cloud@Customer | ✅ | ❌ |
| Exadata On-Premises | ✅ | ❌ |
| Other On-Premises | ❌ | ❌ |
Supported Data Transfer for Logical Migration
Overview of the different supported data transfer methods for logical migration:
| Data Transfer Method | ZDM | DMS |
|---|---|---|
| Object Storage | ✅ | ✅ |
| Database Link | ✅ | ✅ |
| Amazon S3 (Only AWS Migrations) | ✅ | ✅ |
| NFS File Storage | ✅ | ✅ |
| Copy / RSYNC (Not for Autonomous) | ✅ | ❌ |
CPAT Integration
Overview of the Cloud Premigration Advisor Tool (CPAT) integration:
| CPAT | ZDM | DMS |
|---|---|---|
| Integration | ✅ | ✅ |
| Gather Target Properties | ✅ | ✅ |
| FixUp Scripts | ✅ | ✅ |
| Graphical Report | ❌ | ✅ |
Footnotes
-
Not included: Any infrastructure costs used for the migration like compute instance, database service or object storage.
GoldenGate Marketplace Image is free for a period of 183 days. ↩ -
Free for 183 days for migrations running not more than 60 days idle (no transferred data).
Not included: Any infrastructure costs used for the migration like compute instance, database service or object storage.
GoldenGate Marketplace Image is free for a period of 183 days. ↩