Before performing any migration of Flows for APEX, we recommend that you make a backup of your database or schema to avoid any data loss.

SQLcl migration

Each release of Flows for APEX comes with the migration script for the previous version. That means we don’t provide scripts for migrating several version at one time. For example, if your current installation runs the 5.1 version and you want to migrate to 21.1, you have to migrate first form 5.1 to 5.1.2 and then migrate from 5.1.2 to 21.1.

For Windows users, please make sure to set NLS_LANG value correctly by running set NLS_LANG=AMERICAN_AMERICA.UTF8 before using SQLcl.

  1. Get the full distribution content by cloning the repository or downloading the release source code: zip or tar.gz.
  2. Connect to you Oracle schema with SQLcl, make sure you are located into the distribution folder.
  3. Run the migration script.
    SQL> @src/migrate_all.sql
    
  4. Provide the Workspace Name, Parsing Schema, Application Alias, Application Name, the current version and the version you want to upgrade to.
    >> Please enter needed Variables
    Enter Workspace Name: [FLOWS4APEX] FLOWS4APEX
    Enter Parsing Schema: [FLOWS4APEX] FLOWS4APEX
    Enter Application Alias: [FLOWS4APEX] FLOWS4APEX
    Enter Application Name: [Flows for APEX] Flows for APEX
    Enter current installed release (e.g., 21.1): 21.1
    Enter next release to upgrade to (e.g., 22.1): 22.1
    
  5. At the end of the migration, you should see the confirmation that the product have been correctly installed. You can connect to your Oracle APEX builder and run the Flows for APEX application.
    >> Finished Installation of Flows4APEX
    >> ====================================
    

Migration without SQL*Net access

Starting from v22.1 we provide a way to migrate system for which you can’t use SQLcl. Note that it can only be used to migrate from v21.1 to v22.1.

  1. Get the archive no_sqlnet_migration.zip
  2. Import into the APEX builder under SQL Workshop > SQL Scripts.
  3. Run the scripts in the following order
    • 01_migrate_engine_211_221.sql
    • 02_migrate_engine_app_and_data_211_221.sql
  4. Import the packaged app but make sure to not run the supporting objects