1. Migrating Oracle Database Cloud Schema Service Applications to Oracle Cloud Infrastructure
  2. About Migrating
  3. About Migration Task Flow

About Migration Task Flow

The following workflow guides you through the steps to migrate Oracle Application Express (APEX) apps, data and RESTful services from Oracle Database Cloud Schema Service to Oracle Autonomous Transaction Processing or Oracle Autonomous Data Warehouse.

  1. Create the Data Pump export in Schema Service. This export file is used to move all of your existing data objects, apps, and RESTful services.
  2. Stage the Data Pump export file in Oracle Cloud Infrastructure Object Storage.
  3. Connect to Autonomous Database using client credentials and import the schema using the Oracle Data Pump impdp utility.
  4. Create an APEX workspace in Autonomous Database. This workspace will be used to restore your apps and RESTful services.
  5. Restore your APEX apps and workspace files using the APEX Application Archive productivity app.
  6. Import your RESTful services from the APEX Application Archive productivity app using APEX SQL Workshop. Then, migrate imported RESTful services to ORDS-based RESTful services.
  7. Complete Post-Migration tasks in Autonomous Database if applicable.

Once you have completed these steps are able to run your APEX apps. Please note that Oracle Autonomous Database runs Oracle APEX 19.1. Therefore, your apps are upgraded when they are restored. Your apps should run without issue, but should be thoroughly tested. Developers should also go into each app and review the Upgrade Application report within Utilities for any additional upgrades they may want to implement that were not automatically performed.