Database Upgrades and Migrations
Upgrade to Oracle Database 19c for the latest capabilities and long-term support. Accelerate upgrades and migrations with a range of database utilities including the AutoUpgrade tool—which can identify and often automatically resolve migration-blocking issues.
- AutoUpgrade tool
Upgrade one or many Oracle Databases at the command-line with a single command and a single configuration file.
- Upgrade and Migration Youtube Channel
Over 200 training and technical videos on popular topics for Oracle Database upgrades and migrations.
- Upgrade advice
Learn everything you need to know about upgrading to Oracle Database 19c.
Database upgrades and migrations
Complete a simpler, faster, and more predictable upgrade process. Learn more about upgrading Oracle Database with AutoUpgrade by exploring resources, documentation and more.
Hands-free upgrades
Use the Quickstart to plan the upgrade. Upgrade from 11.2.0.4 and higher with the AutoUpgrade Tool using one command and one configuration file, after installing the new binaries and configuring the new release Oracle home(s).
Cloud Migration Advisor
The Oracle Cloud Migration Advisor (CMA) is the best tool for advising you about your migration to Oracle Autonomous Database, Oracle Exadata Cloud at Customer, Oracle Exadata Cloud Service, and other Oracle Cloud Infrastructure (OCI) Database services—and more.
CMA collects database metadata details about your current Oracle Database environment, including patch levels. (No business data or customer information is collected.) CMA uses this database metadata to provide detailed technical advice about possible migration targets and methods.
Choose and download the most appropriate metadata collection method for your situation:
- Cloud Pre-Migration Advisor Tool (CPAT) (Use Oracle SQLcl MIGRATEADVISOR Command, see Jeff Smith's blog post — or if you can't use SQLcl, Download CPAT from My Oracle Support Note 2758371.1 — Documentation (PDF))
- SQL CSV script (Download — Documentation (PDF))
- Oracle Enterprise Manager script (Download — Documentation (PDF))
- Spreadsheet (Download — Documentation (PDF))
The documentation for each method describes how to collect the metadata and share it with your Oracle advisor.
Move data and metadata among Oracle Databases and Oracle Cloud
Consider Data Pump best practices for high-speed, parallel export and import of data and metadata. Migrate faster and easier with Data Pump Full Transportable Export and Import. Adhere to Oracle Cloud migration best practices.
- Oracle Database Utilities guide
- Move to Oracle Cloud
- Load data into Oracle Autonomous Transaction Processing (ATP)
- Load data into Oracle Autonomous Data Warehouse (ADW)
- Oracle Zero Downtime Migration home page
- Migrate with SQL Developer
- Oracle Enterprise Manager Database Migration Workbench
- OCI Database Migration
Fast external data ingest
Perform high-speed data filtering and loading from external files into Oracle Database tables using Oracle SQL*Loader Express Mode Loading. Access data in external sources as External Tables from SQL, PL/SQL and embedded SQL.
Move to Oracle Database 19c
-
Take advantage of new and improved capabilities in Oracle Database Release 19c
Oracle Database 19c offers the productivity, manageability and security benefits of a converged database and the longest term of support.
-
Move to the long-term supported release of Oracle Database
The long-term support for Oracle Database 19c provides the highest level of release stability and longest duration of support and bug fixes, giving you the most stable platform for your applications.
Get started
Try Oracle Cloud Free Tier
Build, test, and deploy applications on Oracle Cloud for free.
Get certified
Access online training and certifications for Oracle Database cloud services.
Contact us
Interested in learning more? Contact one of our experts.