Migrate Applications and Data

About Migrating Applications

Oracle Application Express Applications, RESTful services, and dependent database objects can be moved between Oracle Databases, whether the Oracle Database resides on-premises, or in a Database Cloud Service such as Oracle Database Exadata Express Cloud Service, or in Oracle Autonomous Database.

There are several different methods and tools that can be used to perform the migration. Some options include:

Oracle Application Express Import/Export to create export files that can be imported into another Oracle Application Express workspace
Oracle SQL Developer to drag and drop carts of data objects
Oracle Application Express SQL Workshop to create database objects and populate them with data
RESTful Web services to load database objects with data

See Develop on the Database.

Migrate On-premises Applications to Oracle Database Exadata Express Cloud Service

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

The migration process involves using Oracle Application Express, from the on-premises Oracle Database, to create an application export and generate a report that identifies application dependent database objects. The export is imported to Exadata Express, using Oracle Application Express, and the dependent objects are moved to Exadata Express using Oracle SQL Developer. See How to Move an Application to Another Instance in Oracle Application Express Application Builder User’s Guide.

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 Exadata Express must be performed by a Service Administrator.

Note:

You can only import applications from Oracle Application Express versions that are the same version as the destination Oracle Application Express or are an earlier version.

From the on-premises Oracle database, create an application export from the on-premises database and find out which database objects the application needs :

From the on-premises Oracle Database, use Oracle Application Express to 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. Go to the on-premises Oracle Application Express Builder.
  The Oracle Application Express Builder page appears.
2. Select the application you want to migrate.
  The Application Edit page displays.
3. Click Export / Import.
  The Import / Export dialog appears.
4. Click Export.
  The Application Export page appears.
5. For File Format, select the format in which you want to view the export.
6. For Export Supporting Object Definitions, select No.
7. Click Export.
  The application export file is created.
8. Save the export file locally.
Generate a Database Object Dependencies report for the application.
1. Go back to the Application Edit page, by clicking the application name at the start of the breadcrumb.
2. Click Utilities.
  The Utilities page displays.
3. Click Database Object Dependencies.
  The Database Object Dependencies page appears.
4. Click Compute Dependencies.
  The Database Object Dependencies for this application display.
  
  Note:
  This report is needed by a subsequent step to identify which data objects must be moved.
From Exadata Express, use Oracle Application Express to import the application export. See Importing Export Files in Oracle Application Express Application Builder User’s Guide .
1. Access Oracle Application Express in Exadata Express. See Access Oracle Application Express.
  The Oracle Application Express home page appears.
2. Click Application Builder.
  The Application Builder home page displays.
3. Click Import.
  
  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.
Use Oracle SQL Developer to move database objects from the on-premises Oracle Database to Exadata Express.
1. Locate the Database Object Dependencies report you generated in an earlier step.
2. Use Oracle SQL Developer to drag and drop required database objects, listed in the report, from the on-premises Oracle Database to Exadata Express. Follow steps outlined in About Manage.
You have completed the application migration process and are ready to run the migrated application inExadata Express.

Migrate Oracle Database Exadata Express Cloud Service Applications to On-premises Oracle Databases

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

The migration process involves using Oracle Application Express, from Exadata Express, to create an application export and generate a report that identifies application dependent database objects. The export is imported to the on-premises Oracle Database, using Oracle Application Express, and the dependent objects are moved using Oracle SQL Developer. See How to Move an Application to Another Instance in Oracle Application Express Application Builder User’s Guide.

Note:

Exporting Oracle Application Express applications from Exadata Express 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:

You can only import applications from Oracle Application Express versions that are the same version as the destination Oracle Application Express or are an earlier version.

To move applications from Exadata Express to an on-premises Oracle Database :

From Exadata Express, use Oracle Application Express to create an application export file. See Understanding the Deployment Process in Oracle Application Express Application Builder User’s Guide .
1. Access Oracle Application Express in Exadata Express. See Access Oracle Application Express.
  The Oracle Application Express Builder page appears.
2. Select the application you want to migrate.
  The Application Edit page displays.
3. Click Export / Import.
  The Import / Export dialog appears.
4. Click Export.
  The Application Export page appears.
5. For File Format, select the format in which you want to view the export.
6. For Export Supporting Object Definitions, select No.
7. Click Export.
  The application export file is created.
8. Save the export file locally.
Generate a Database Object Dependencies report for the application.
1. Go back to the Application Edit page, by clicking the application name at the start of the breadcrumb.
2. Click Utilities.
  The Utilities page displays.
3. Click Database Object Dependencies.
  The Database Object Dependencies page appears.
4. Click Compute Dependencies.
  The Database Object Dependencies for this application display.
  
  Note:
  This report is needed by a subsequent step to identify which data objects must be moved.
From the on-premises Oracle Database, use Oracle Application Express to import the application export. See Importing Export Files in Oracle Application Express Application Builder User’s Guide .
1. Go to the on-premises Oracle Application Express Builder.
  The Oracle Application Express home page appears.
2. Click Application Builder.
  The Application Builder home page displays.
3. Click Import.
  
  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.
Use Oracle SQL Developer to move database objects from Exadata Express to the on-premises Oracle Database.
1. Locate the Database Object Dependencies report you generated in an earlier step.
2. Use Oracle SQL Developer to drag and drop required database objects, listed in the report, from Exadata Express to the on-premises Oracle Database. Follow steps outlined in About Manage.
You have completed the application migration process and are ready to run the migrated application in your on-premises Oracle Database.

Migrate from Oracle Database Exadata Express Cloud Service to Oracle Autonomous Database

Oracle Autonomous Database delivers self-driving, self-securing, self-repairing database services that scale instantly to meet the demands of mission critical applications.

See About Migrating Oracle Application Express Applications to Oracle Autonomous Database in Migrating Oracle Exadata Express Cloud Service Apps to Oracle Cloud Infrastructure.