Oracle Database Migration

Migrate your legacy Oracle databases to Alibaba Cloud to save on long-term costs and take advantage of improved scalability, reliability, robust security, high performance, and cloud-native features.

Overview

In 2019, Gartner asserted, "The Future of the DBMS Market Is the Cloud." Alibaba Cloud’s Oracle Database Migration solution can help you easily and efficiently migrate Oracle databases to the cloud. You can achieve low costs, high efficiency, auto-scaling, and cloud-native transformation based on Alibaba Cloud’s world’s leading cloud-native database technology.

The Oracle Database Migration solution provides scientific methodologies, standard migration processes, supporting tools, and professional services to help you smoothly migrate Oracle databases in various deployment modes to a public cloud, hybrid cloud, or private cloud. Prior to the migration, you can use Alibaba Cloud’s Advanced Database & Application Migration (ADAM) to assess the migration feasibility, select appropriate destined databases, determine the migration risks, and estimate the workload, costs, and duration of Oracle database migration.

Highlights of the Oracle Database Migration Solution

  • Intelligent Readiness Assessment with ADAM

    Alibaba Cloud ADAM provides a professional database and application compatibility assessment report that helps you select appropriate databases, quantify uncertain factors, and formulates a comprehensive Oracle database migration plan that includes migration risks, transformation workload, migration costs, and duration.

  • High Compatibility with Oracle Syntax

    Alibaba Cloud’s cloud-native database ApsaraDB for PolarDB (PolarDB-O) is highly compatible with the Oracle syntax engine. This minimizes changes to the database and applications and reduces the workload of Oracle database migration significantly.

  • Smooth Migration with Zero Downtime

    Alibaba Cloud has a matured methodology of Oracle database migration with a standardized process to ensure a smooth migration. The process includes the migration assessment tool, ADAM, a reliable migration tool, DTS, destined cloud-native databases with high compatibility with Oracle syntax, and professional service.

  • Leading Cloud Databases

    Alibaba Cloud was named a Leader in Gartner’s 2020 Magic Quadrant for Cloud Database Management Systems (DBMS). The destined cloud databases helped the world’s largest shopping festival run smoothly (even during peak hours.)

Perform a Migration Readiness Assessment

Use Alibaba Cloud's Advanced Database & Application Migration (ADAM) to profile your Oracle source database, evaluate the compatibility, specifications, and migration risks of potential destination databases, and estimate the destination database costs.

Learn More Contact Sales

The Three-Step Oracle Database Migration Process

Alibaba Cloud’s Advanced Database & Application Migration (ADAM) quantifies the database selection, migration risks, compatibility, and transformation workload to guide you through decision-making during the Oracle database migration. The three steps are listed below:

1. Business Research
Conduct research on the current databases and applications of your organization to assess the Oracle database migration. This process consists of background research, source database research, application research, and architecture research.
2. Feasibility Assessment
After the business research is completed, select an appropriate target database and formulate a detailed assessment plan to access the compatibility, performance, and migration risks of the target database.
3. Feasibility Verification
After the migration assessment is completed, select a representative module (such as the typical transaction settlement module) in the migration business, perform proof of concept (POC) testing on the target database to verify the feasibility of Oracle database migration, and issue a POC verification report.

For a step-by-step guide of how to use ADAM, see Performing a Readiness Assessment for an Oracle Database Migration to Alibaba Cloud.

Advanced Database & Application Migration

Easy transformation for heterogeneous database

Learn More

Data Transmission Service

Data migration and data synchronization

Learn More

ApsaraDB for PolarDB

A next-generation relational database

Learn More

Data Transmission Service (DTS) enables smooth database migration, ensures data accuracy and consistency, and supports business rollback upon anomalies. DTS can synchronize data in real-time, reducing system downtime and migration risks. The Oracle database migration contains three steps:

1. Business Transformation and Verification
After POC verification, conduct overall transformation, testing, and verification on the business system in terms of functions, performance, stability, reliability, security, scalability, migration plans, and rollback plans.
2. Cutover Drill
Conduct a cutover drill to test the functions, performance, and stability of the business system in a simulated release environment before production cutover. We recommend taking at least three to five cutover drills.
3. Production Cutover
Formulate cutover processes based on different business systems and assign process owners to take charge of each step to ensure successful production cutover.

Alibaba Cloud’s professional database service team can help you continuously monitor the business system and database to ensure smooth business operation and perform emergency troubleshooting and performance optimization. Also, we can create training plans as required.

Advanced Database & Application Migration

Easy transformation for heterogeneous database

Learn More

Data Transmission Service

Data migration and data synchronization

Learn More

ApsaraDB for PolarDB

A next-generation relational database

Learn More

This Oracle Database Migration solution mainly applies to OLTP. The destined cloud-native database PolarDB comprises PolarDB for MySQL, PolarDB for PostgreSQL, and PolarDB-O. They adopt the same architecture, but each one supports a different database engine. You can use ApsaraDB for PolarDB to innovate business successes.

ApsaraDB for PolarDB (PolarDB-Oracle) is a next-generation relational cloud-native database independently developed by Alibaba Cloud. It is highly compatible with the Oracle syntax engine, separates computing from storage, and supports scaling-up computing power to 1,000 cores and storage capacity to 100 TB. It integrates the stability, availability, security, and strong data consistency of centralized databases, and the flexibility and scalability of cloud-native databases. For more information, see Leverage the World's Leading Cloud-Native Database Capabilities.

Alibaba Cloud also supports OLAP database migration. Contact us for more information.

Advanced Database & Application Migration

Easy transformation for heterogeneous database

Learn More

Data Transmission Service

Data migration and data synchronization

Learn More

ApsaraDB for PolarDB

A next-generation relational database

Learn More

Talk to Database Experts for Oracle Database Migration

Contact Sales

Leverage the World's Leading Cloud-Native Database Capabilities

Elasticity Management

ApsaraDB for PolarDB provides cloud-native elastic management capabilities. It enables cluster upgrade/downgrade, storage scale-in/scale-out, and in-service upgrade to enhance business write performance and reduce the risks of changing resource configurations by traditional means. With features such as automatic load balancing and read/write isolation, it automatically routes read/write business. It also allows you to flexibly add and remove read-only cluster nodes in service to deal with query requests at high queries per second (QPS) during peak hours.

Spatio-Temporal Processing

New business scenarios, including map services, vehicle monitoring, logistics distribution, and trajectory analysis, pose new requirements to the storage and management of time data and spatial geographical location data. Ganos is the powerful built-in spatio-temporal operation engine of ApsaraDB for PolarDB. It provides spatio-temporal data models, indexes, and operators that comply with SQL and SQL/MM standards to achieve unified storage and seamless association with business data and facilitate integration. The spatio-temporal multi-model SQL engine provides dedicated data types and functions. It can comprehensively process information and respond to a query for 100,000 "locations and events" in billions of data records within milliseconds, providing a new SQL query pattern based on a 5G + IoT platform. It can be applied to intelligent map navigation, intelligent logistics, IoV tracking, city brain, and other scenarios

Hot and Cold Data Separation

As businesses grow, the data volumes of core business tables in the database increase. In the OLTP-oriented database architecture of Oracle, table expansion frequently occurs, affecting the business query efficiency. The cloud-native oss_fdw plug-in separates hot data and cold data for storage. Based on the plug-in, cold data is stored in Object Storage Service (OSS), enabling unlimited storage of massive cold data. Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) tunnels can be connected to transmit business data to the data warehouse. This enables report queries and online and offline big data analysis, providing decision-making support for enterprise customers.

Talk to Database Experts for Oracle Database Migration

Contact Sales

Customer Success Stories

PrestoMall, previously known as 11street Malaysia, is Malaysia’s largest homegrown online shopping platform. It is a part of Presto, Malaysia’s first homegrown multi-service lifestyle app that offers convenient features and hassle-free mobile payments.

PrestoMall incurred high IT costs and poor database elasticity as the business developed rapidly. Alibaba Cloud’s solution gave PrestoMall a professional database and application compatibility assessment to formulate a comprehensive database migration plan. It leveraged real-time data migration and expert services to reduce costs and time, migrating applications from the Oracle database to the cloud smoothly and efficiently.

Bybon is Apple's largest authorized service agent in China. It was founded in 2007 and currently has 150 service centers in 100 cities across China, with 1,200 maintenance engineers and more than 50 million mobile terminal users.

Bybon’s business applications were deployed on Alibaba Cloud, but its database could not be migrated to the cloud, resulting in network latency and poor business availability. Alibaba Cloud’s solution helped Bybon analyze the business code and adjust their database migration plan based on scenario and process. Then, Bybon replaced its database with ApsaraDB for PolarDB, which is 90% compatible with the original system, and reduced the migration workload. The cloud-based applications and database accelerated the network speed and improved business system availability.

Related Resources

Analyst Report

Gartner Magic Quadrant for Cloud Database Management Systems

Alibaba Cloud is named Leader in Gartner’s 2020 Magic Quadrant for Cloud Database Management Systems (DBMS).

Best Practice

Performing a Readiness Assessment for an Oracle Database Migration to Alibaba Cloud

Profile your Oracle source database, evaluate the compatibility, and estimate the costs.

Whitepaper

Oracle-to-PolarDB Smooth Migration Solution

Introduce our Oracle database migration solution with high efficiency and low costs.

Solution

Database Migration

Migrate to fully managed cloud databases.

Solution

Cloud Database Solutions for FinTech

Leverage cloud-native database solutions dedicated for FinTech.

Solution

Cloud Database Solutions for Gaming

Solve all data problems with matured and customized architectures.

Start with Alibaba Cloud Solutions

Learn and experience the power of Alibaba Cloud.

Contact Sales