Upgrading a Packaged Application

Defining an Upgrade Script

You can use the Upgrade page to define scripts to upgrade database objects, images, and seed data when upgrading an existing application.

To create an upgrade script:

1. On the Workspace home page, click the Application Builder icon.

2. Select an application.

3. Click Supporting Objects.

   The Supporting Objects page appears.

4. Under Upgrade, click Upgrade Scripts.

   Use the Detect Existing Supporting Objects section to determine if the appropriate objects are installed or need to be upgraded.

5. In Query to Detect Existing Supporting Objects, enter a query in the field provided that returns at least one row if the supporting objects exist.

   This query determines whether the user who installs the packaged application is prompted to run the installation scripts or the upgrade scripts.

6. To create a script, click Create.

   
   

   Tip: To enable users to upgrade from various earlier versions of this application, you can add conditions to the upgrade scripts by going to the Script Properties page.

   
   

7. Follow the on-screen instructions.

Upgrading a Packaged Application

After you create your upgrade script, you can test it by clicking Upgrade Supporting Objects on Tasks list on the Supporting Object page.

End users can also use this feature to upgrade an existing packaged application.

To upgrade a packaged application:

1. Import a new version of application to be upgraded (if applicable). See "Importing an Application, Page or Component Export".

2. On the Workspace home page, click the Application Builder icon.

3. Select the application.

4. Click Supporting Objects.

   The Supporting Objects page appears.

5. From the Tasks list, click Upgrade Supporting Objects.

6. Follow the on-screen instructions.