Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Section
Column

Using  version 4.1.7 or later and you want to upgrade to version 5 to take advantage of all the new features? A new menu import item on the Manage Server page is available to help with your upgrade.

The Import /frevvo/data feature is available to the superuser admin only and supports import from the following frevvo GA releases:

  • 4.1.7 and later  
Column
width240px

On This Page:

Table of Contents
maxLevel1

Migrating from HSQLDB

 does not support the use of HSQLDB for use beyond demo/trials of the Live Forms software. If by mistake you continued to use the demo/trial HSQLDB database for production use, you will need to first migrate your data to one of  supported production databases BEFORE you can use the automated migration scripts to upgrade to the latest version of Live Forms.

...

Warning

You will need to upgrade to version 4.1.7 or later before migrating to version 5. Refer to Upgrading Your In House Server to v4.1.7 or later. for the details. When the upgrade to v4.1.7 or later is complete, return to this page and continue with the Upgrading from v4.1.7+ section below:

...

Please read the following upgrade steps prior to starting the migration.

Note

Migration from  v4.1.7+ to v5.1.1 is not supported for the Oracle database. Please contact frevvo customer support for details and help.

  1. Please read and understand the Migration Considerations which may require your action before beginning.
  2. Backup the v4 server's forms and users databases
  3. Backup the v4 server's installation directory so that you have a copy of all custom configuration parameters and the v4 server's data folder.
  4. Stop the v4 server using stop-frevvo.[bat,sh] or through the Computer Management Services console if  is running as a window's service. It is very important that the v4 server is stopped, otherwise the v5 server may not correctly migrate all existing tenant users.
  5. Download a fresh v5  server:
    1. Download the latest v5 software. Note that you will need to provide your login credentials to download the software.
    2. Request a v5 license key by emailing emailing support@frevvo.com. Your v4 license key will not work with version 5 of . You must email frevvo to obtain a functional v5 license key.
    3. The download is a zip file. Extract the contents to any folder of your choice. This folder will be refered to as <frevvo-home> (note that the zip already contains a top level frevvo folder).   
  6. Migrate existing 4.1.7 forms & users databases using the upgrade scripts provided in <frevvo-home>/data/sql. You must execute these SQL scripts to perform a few required database schema updates.
    1. Navigate to <frevvo-home>/data/sql. 
    2. The scripts are named by database and by release number of the Live Forms version that you are upgrading from. For example, if your  databases use mySQL5, and since you can only upgrade form versions 4.1.7 or later - use the scripts that have "mysql5" and 417 in its name:

...

Info

If you are upgrading from  v4.1.8, v4.1.9, v4.1.10 or v4.1.911, run the v4.1.7 scripts for Step 6.

...

  1. Please read and understand the Migration Considerations which may require your action before beginning.
  2. Backup the v5 server's forms and users databases
  3. Backup the v5 server's installation directory so that you have a copy of all custom configuration parameters
  4. Stop the v5 server using stop-frevvo.[bat,sh] or through the Computer Management Services console if is running as a window's service. It is very important that the v5 server is stopped, otherwise the new v5 server may not correctly migrate all existing tenant users.
  5. Install a fresh v5 server:
    1. Download the latest v5 software. Note that you will need to provide your login credentials to download the software.
    2. Request a v5 license key.
    3. The download is a zip file. Extract the contents to any folder of your choice. This folder will be refered to as <frevvo-home> (note that the zip already contains a top level frevvo folder).  
  6. Configure the new installation

...

If you are using the database connector, you must reinstall and configure it again for the v5 installation. Version 5 includes the latest database connector, version 2.3 beta.