About Migration Task Flow

The following workflow guides you through the steps to migrate from Oracle Database Exadata Express Cloud Service to Oracle Autonomous Transaction Processing or Oracle Autonomous Data Warehouse.

1. Export your apps with APEX Application Archive app and RESTful services with SQL Workshop.
2. Export your databasse schema to an Oracle Cloud Infrastructure Object Storage Classic container.
3. Move the Data Pump export file from Oracle Cloud Infrastructure Object Storage Classic to Oracle Cloud Infrastructure Object Storage.
4. Connect to Autonomous Database using client credentials and import the schema using the Oracle Data Pump impdp utility.
5. Create an APEX workspace in Autonomous Database. This workspace will be used to restore your apps and RESTful services.
6. Restore your APEX apps and workspace files using the APEX Application Archive productivity app.
7. Import your RESTful services using SQL Workshop.
8. Complete Post-Migration tasks in Autonomous Database, if applicable.

Once you have completed these steps, you 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.