Oracle provides strategies, solutions, tools, and services for online and offline database migrations. Free planning advisors, automation, and step-by-step guides help you perform non-disruptive and validated migrations.
Migrate databases while applications are online.
Move from any version, platform, and OS to any OCI Database service, including Exadata, Cloud@Customer, and Autonomous.
Choose easy-to-use user experiences that simplify even the most complex scenarios or assemble workflows for exceptional situations.
Advisors help you choose target databases, efficient estate migration, and best practice methods.
Upgrade and migrate simultaneously in a streamlined migration workflow.
Transfer licenses and workloads with BYOL for discounted rates, support fee offsets, and more.
Oracle’s best practice planning advisors and automated solutions help you through your migration lifecycle. Supported by zero downtime technologies and enterprise-class database utilities, applications can remain online during migrations, enabling the least risk, disruption, and cost.
Plan | Prepare | Execute | Validate |
---|---|---|---|
|
|
|
|
Best practice planning tools allow you to make strategic and tactical decisions, from choosing the best database to migrating with the least effort and business disruption. Fine-tune a migration method that considers acceptable downtime, upgrade considerations, and DBA skills.
Evaluate source databases with the Cloud Premigration Advisor Tool (CPAT) against target database and platform to identify upgrades, prioritize exceptions, and suggest resolutions. Use step-by-step guides to provision environments and iteratively test migration workflows.
Three automated alternatives streamline and orchestrate migration workflows using Oracle Database utilities for offline migrations. For online migrations, high availability and standby capabilities are added. Finally, additional technologies validate performance and ongoing synchronization.
Beyond ensuring data movement, SQL Performance Analyzer can prove operational readiness by comparing source versus target performance. For complex online migrations, Oracle GoldenGate Veridata guarantees that sources and targets are synchronized. GoldenGate Veridata and Enterprise Manager may require additional licensing.
All solutions validate data and data object movement.
Ensures the target database performs better than the source. Part of Oracle Real Application Testing.
Ensures that source and targets are synchronized.
The best migration method considers business and technical planning factors. Oracle offers automated solutions that simplify and streamline upgrade and migration workflows using embedded Oracle utilities, Database options, and supporting products. DBAs can also use Oracle Database utilities to custom engineer their own migration workflows.
Migration workflows meet both simple and complex operational requirements. Migrations can run whether applications are online or offline at the source or the target and within or across firewalls. For online migrations, an initial load is followed by applying ongoing incremental changes. Logical workflows can also include version upgrades.
Offline migration
Online migration
Logical migration
Physical migration
Direct connection
OCI Database Migration migrates Oracle Databases from on-premises or cloud deployments to OCI. The easy-to-use graphical user experience validates and manages migration workflows. Database Migration transparently uses Zero Downtime Migration, Cloud Premigration Advisor Tool, Data Pump, and GoldenGate services for secure, fault-tolerant, and incremental migrations.
Zero Downtime Migration (ZDM) offers online/offline and physical/logical workflow options and allows for inline version upgrades. ZDM is executed through command-line interface (CLI) and REST APIs. The Cloud Premigration Advisor Tool is integrated into the logical workflow. No licensing of Data Guard or GoldenGate is required.
The Migration Workbench offers physical/logical and offline workflow options. Workflows are managed with a graphical user experience, CLI, and REST APIs. The CPAT is embedded into the Data Pump workflow. Enterprise Manager is licensed software that includes Migration Workbench and SQL Performance Analyzer.
Oracle Database includes free and essential tools for DBAs to manage their databases including developing and managing custom migration scenarios. These tools are also embedded into the automated migration solutions. GoldenGate offers additional online capabilities. See the FAQ to learn more about each one.
Specific scenarios to move data between containers.
Supports zero downtime migrations by capturing and applying changed data.
Oracle Zero Downtime Migration
“Using Oracle Zero Downtime Migration, we were able to move multiple databases to OCI in a single weekend. It would have taken us at least two years and a lot of headaches to migrate them one by one.”
OCI Database Migration
“Until OCI Database Migration service, we had to dedicate our most experienced DBAs to manage the variety of Oracle tools. With OCI DMS, all the setup, administration, validation, and workflow needed for zero downtime migrations is automated and happens behind the scenes.”
Oracle Enterprise Manager Migration Workbench
“We rely on Oracle Enterprise Manager to manage our Oracle fleet of applications and database environments in the cloud and on-premises across the globe. We are excited about the new EM release that will further simplify migrating workloads to Oracle Cloud Infrastructure with improved visibility and better quality of service.”
Oracle Enterprise Manager Migration Workbench
“In today’s hybrid IT environment, it’s crucial that customers not only be able to monitor and manage Oracle Databases across both cloud and on-premises, but also seamlessly to move them. The new Migration Workbench in Oracle Enterprise Manager should help customers make the database transition to cloud easier and with very high levels of confidence.”
Oracle Cloud Lift Services provide guidance from cloud engineers on planning, architecting, prototyping, and managing cloud migrations.
Use existing Oracle software licenses in OCI for discounted hourly usage fees.
Choose an experienced Oracle global partner to help you plan and perform your database migration.
With Oracle Support Rewards, Oracle customers can reduce their technology software license support bill—even down to zero.1
Oracle offers a Free Tier with no time limits on selection of services, such as Autonomous Database, Compute, and Storage, as well as US$300 in free credits to try additional cloud services.
Interested in learning more about Oracle Database Migrations to Oracle Cloud Infrastructure? Let one of our experts help.
1. Reduction in tech support bill is subject to regional tax regulations. Taxes cannot be paid with rewards and only the pretax invoice amount can be paid with rewards.