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 must be upgraded.

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

   This query determines whether the user who installs the custom 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.