Proactive insights, news and tips from Oracle Fusion Middleware Support. Learn Oracle from Oracle.

How to: Move APEX Applications to Autonomous Database cookbook

Fancy moving your Oracle APEX applications on Oracle Autonomous Database?

Then you may benefit from the complete cookbook, with examples, that demonstrates how to accomplish this move offered by Joel Kallman, the Product Manager of Oracle Application Express here!

The High-Level Steps from the cookbook:

You can follow the steps below to move your APEX applications, associated data schemas, and local RESTful services to Autonomous Database:

  1. Archive your APEX applications - This step copies your APEX application definitions into your local schema
  2. Export your data schema(s) - This will be used to move all of your exiting data objects and data
  3. Stage your export file(s) - Copy the Data Pump export file into the Oracle Cloud Infrastructure Object Storage
  4. Connect to Autonomous Database and Import File - Your data schema(s) will now be moved
  5. Create an APEX Workspace - Define your new APEX workspace where your applications will be restored
  6. Remove database objects and install APEX Application Archive App - Run a small SQL script to remove the objects which prevent the APEX Application Archive App from installing
  7. Restore the APEX Applications - Using the APEX Application Archive productivity app, you can easily restore all of your APEX applications
  8. Copy ORDS RESTful Services - If you have defined RESTful Services on-premises then use this step to copy them to the cloud
  9. Complete post migration tasks in Autonomous Database, if applicable.

More on Autonomous Database here!

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.