Export APEX Apps and RESTful Services in Exadata Express

The APEX Application Archive productivity app ships with Oracle Application Express (APEX) and allows you to quickly create archives of your apps and workspace resources. These archives are stored in tables which are created if they don't yet exist.

You can archive your apps so they can be moved by doing a schema export from your Exadata Express instance and import into your Autonomous Database instance. In your Autonomous Database instance, you simply install the same APEX Application Archive app, which works against the imported tables, and allows you to easily restore these applications in your new workspace.

To export APEX apps:

1. Log in to your Exadata Express workspace.
2. From the App Builder home page, click Create and choose Productivity App.
3. Find the APEX Application Archive app in the App Gallery list and click Install App.
4. Click Next and Install App.
5. Click Run App icon.
6. Accept the defaults and click Complete Setup.
7. Click Archive Applications.

   
   Description of the illustration archive_apps.png

8. Ensure all applications are in the right side of the shuttle. Click Next and then Create Archive.

   
   Description of the illustration create_archive.png

9. Repeat this process for all workspaces you wish to import into your Autonomous Database.

To export RESTful services:

1. Sign in to your Exadata Express workspace and click SQL Workshop, then click APEX RESTful Services.
2. Click the Export button.
3. Choose All Services from the RESTful Service select list, then click Export and save the SQL file.