Migrate from Database Schema Service to On-premises Oracle Databases

Oracle Application Express applications and data in Oracle Database Cloud Schema Service can be migrated to an on-premises Oracle Database.

The migration process involves using Oracle Application Express to create an application export that includes the metadata and supporting objects used by the application, and then importing the export to the on-premises Oracle Database.

For more information on creating application exports, see Understanding the Deployment Process in Oracle Application Express Application Builder User’s Guide. For more information on importing application exports, see Importing Export Files in Oracle Application Express Application Builder User’s Guide.

Note:

Exporting Oracle Application Express applications from Schema Service must be performed by a Service Administrator. Importing the exported packaged application to an on-premises Oracle Database must be performed by a Workspace Administrator.

Note:

Because Oracle Application Express 5 is the current version available in Schema Service, only Oracle Application Express 5 applications can be migrated.

To move applications from Schema Service to an on-premises Oracle Database:

1. Create an application export file from Schema Service. For further details regarding the steps below, see Understanding the Deployment Process in Oracle Application Express Application Builder User’s Guide.
   1. Access the Oracle Application Express home page located in Schema Service.
      The Oracle Application Express home page appears.
   2. Click Application Builder.
      The Application Builder home page displays.
   3. Click the application you want to migrate.
      The Application home page appears.
   4. Click Export / Import as shown below.
      

      The Export/Import page displays.

   5. Click Export then Next.
      The Export page appears.
   6. Select the Workspace subtab.
      The Export Workspace page displays.
   7. For File Format, select the format in which you want to view the export and click Export Workspace.
      The Packaged Application Export file is created.
   8. Save the export file locally.
2. Import the application export to your destination on-premises Oracle Database. For further details regarding the steps below, see Importing Export Files in Oracle Application Express Application Builder User’s Guide.
   1. Access Oracle Application Express in the destination on-premises Oracle Database.
      The Oracle Application Express home page appears.
   2. Click Application Builder.
      The Application Builder home page displays.
   3. Click Import as shown below.
      

      The Import page appears.

   4. For Choose File, navigate to the application export file you created in previous steps and select it.
   5. For File Type, select Database Application, Page or Component Export and click Next.
      The File Import Confirmation page displays.
   6. To install now, click Next.
   You have completed the application migration process and are ready to run the migrated application in your on-premises Oracle Database.