Migrate On-premises Applications to Database Schema Service

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

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 Schema Service.

For more information on creating application exports in Oracle Application Express, 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. For information on using Oracle SQL Developer to import data objects to Database as a Service, see Using Oracle SQL Developer for Data Loading.

Note:

Exporting Oracle Application Express applications from an on-premises Oracle Database must be performed by a Workspace Administrator. Importing the exported packaged application to Schema Service must be performed by a Service 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 an on-premises Oracle Database to Schema Service:

1. Using Oracle Application Express, create an application export file from the on-premises Oracle Database. See Understanding the Deployment Process in Oracle Application Express Application Builder User’s Guide.
   1. Access the Oracle Application Express home page located in the on-premises Oracle Database.
      The Oracle Application Express home page appears.
   2. Click Application Builder.
      The Application Builder home page appears.
   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 Application 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 application export file is created.
   8. Save the export file locally.
2. Import the application export to your destination Schema Service. See Importing Export Files in Oracle Application Express Application Builder User’s Guide.
   1. Access Oracle Application Express in the destination Schema Service.
      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 Schema Service.