Migrate Oracle Databases with a safety net using Migration Workbench

August 26, 2022 | 3 minute read
Rajendra Patil
Product Manager
Text Size 100%:

Businesses are on a journey to migrate legacy Oracle Databases to new versions and new platforms. These new platforms could be cloud or Exadata Engineered Systems. Architects and Administrators want a solution to securely migrate these databases with minimal downtime and ensure migrated databases are performant for applications’ seamless interaction.

Enterprise Manager Database Migration Workbench helps you quickly and securely migrate databases to various destinations like new Exadata, ExaCC, ExaCS, DBCS, and Autonomous. Migrations can be done without impacting the source database thus, ensuring they are fully operational during the migration process and minimizing application downtime.

Migration Workbench can migrate a full database, or only schemas or required tablespaces. It can also migrate source databases to a multi-tenant environment.

Three popular business reasons to migrate databases:

  • Lift and shift your workload to Oracle Cloud
  • Standardizing on Multitenant architecture
  • Re-platform to new infrastructure

Migration Workbench offers:   

  • End-to-end automation using REST APIs or an intuitive user interface
  • Pre and post-migration performance analysis of databases, by default
  • Real-time progress tracking of migration, fix, pause and resume operations
  • Choice of migration methods – Oracle Data Pump and Transportable Tablespace
  • Encrypted data backup and data movement across the network

With Migration Workbench, you can migrate all database types from 11g to 21c from various source platforms to Linux as shown in the matrix below:

Figure 1: Migration Workbench support matrix
Figure 1: Migration Workbench Support Matrix

Migration Workbench is a one-stop dashboard for creating, customizing, and performing analysis of all types of migrations.

Database Migration Workbench guides: planning to post-migration performance comparison

  • Plan: Assess the source database and resource availability for the destination database
  • Migrate: Customize, include pre and post scripts, schedule, track progress, and troubleshoot in real-time
  • Analyze: Automatic performance analysis of source and destination workload after migration
Figure 2: Migration Workbench activity page
Figure 2: Migration Workbench Activity Page

This is the end of Part 1 of a two-part blog series, Migration Workbench Introduction. Look for Part 2 of this series, including two interesting migration scenarios, "Re-platform Oracle Databases using Migration Workbench" and "Migrate Oracle Databases of varying size using Migration Workbench"

Get hands-on migration experience with Oracle LiveLabs:

Resources:

For a demo on Migration Workbench, visit Migrate Databases with minimal downtime using Migration Workbench.

For more documentation and other resources on Migration Workbench, visit EM Database Migration Workbench and EM Database Management.

 

Rajendra Patil

Product Manager


Previous Post

Automate and scale database security with efficient vulnerability checks

Shiva Prasad | 4 min read

Next Post


Jupyter Notebook integration with OCI Application Performance Monitoring

Robert Brouwer | 4 min read