Using SQL Developer to export or import an Apex application is not only easy, it’s also fast!
To export, follow these steps:
Open the connection to the schema where you’re application is located and search for the “Application Express” directory:
Right click on the application you want to export and choose “Quick DDL” > “Save to File…”:
When done, you’ll have the same file as you would have exported from the Apex GUI.
To import an application, right click on the “Application Express” directory, and choose “Import Application”. You can also right click on an existing application; the next steps are the same.
Follow the wizard. When this screen appears, you can choose to do a number things:
- Auto Assign Application ID
- Use the application ID from the export
- Specify New ID
When the ID that you want to use is already assigned in your workspace, don’t forget to check the “Overwrite” checkbox.
At the end of the wizard you see the progress of the installation:
When finished, you’re application is up and running.