| Warning |
|---|
Though most forms created on v4 will continue to run without any manual action on your part when upgraded to v5, there are a few migration items that you need to consider. Please read and understand the Migration Considerations Planning for v5 which may require your action. |
| Section | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
|
Migrating from HSQLDB
frevvo does 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 frevvo data your data to one of frevvo's 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. Return . 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: |
Upgrading from v4.1.7+
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. |
- Please read and understand the Migration Considerations which may require your action before beginning.
- Backup the v4 server's forms and users databases
- 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.
- 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.
- Install Download a fresh v5 .1 frevvo server server:
- Download the latest v5 software. Note that you will need to provide your login credentials to download the software.Request a .
- Request a v5 license key by 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.
- 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).
- 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.
- Navigate to <frevvo-home>/data/sql.
- 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:
...
Consult your DBA or your database specific documentation on how to run these scripts.
| Info |
|---|
If you are upgrading from v4.1.8, v4.1.9, v4.1.10 or v4.1.11, run the v4.1.7 scripts for Step 6. |
7, . Configure the new installation
...
11, Enter the path to the v4.1.7 <frevvo-home>/data folder that you want to import into this installation.
| Note |
|---|
checks the .user version and stops the import if the version is not 4.1.7+. Here is an example of the error message if the version you are migrating from is v4.1.4 : "Unsupported migration version: found 4.1.4, but expecting version 4.1.7 or later". |
12. Click Import.
All tenants and users in the users database should now be imported into the v5.1 database.
...
If you are running Live Forms for Confluence please follow the same instructions above to upgrade your frevvo form serveryour server. Then you must also install the new version of the Live Forms confluence addConfluence Add-on into your Confluence server. The server and the confluence add-on versions must match.
...
If you are using the database connector, you must reinstall and configure it again for the v5 .1.1 installation. Version 5 .1.1 includes the latest database connector, version 2.3 beta.
Upgrading from v5.x
...
| Warning |
|---|
5.x versions of do not require the migration of the <frevvo-home>/data as all user data is already moved from the filesystem to the database. |
...
|
Please read the following upgrade steps prior to starting the migration.
- Please read and understand the Migration Considerations which may require your action before beginning.
- Backup the v4 v5 server's forms and users databases
- Backup the v4 v5 server's installation directory so that you have a copy of all custom configuration parameters and the v4 server's data folder.
- Stop the v4 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 v4 v5 server is stopped, otherwise the new v5 server may not correctly migrate all existing tenant users.
- Install a fresh v5.1 frevvo serverv5 server:
- Download the latest v5 software. Note that you will need to provide your login credentials to download the software.
- Request a v5 license key.
- 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).
- 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.
- Navigate to <frevvo-home>/data/sql.
- 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:
- forms-mysql5-upgrade-417.sql
- users-mysql5-upgrade-417.sql
Consult your DBA or your database specific documentation on how to run these scripts.
...
- Configure the new installation
- If you made changes to the following files in your v4.1.7 v5 installation, you will need to make the same changes in the new v5 .1.1 configuration files.
- <frevvo-home>/tomcat/conf/server.xml
- <frevvo-home>/tomcat/conf/Catalina/localhost/frevvo.xml
- We recommend that any changes that were made to the web.xml file be moved to frevvo.xml instead.
- The three files mentioned above include:
Refer to Installation Tasks for more information.
87. Start the v5 .1 server. Enter the new v5 .1 license key obtained in Step 5b .
9. Login as admin superuser
| Warning |
|---|
Do NOT login as any user in any tenant other than default before the import: it will create a .user file in the db and will make the import skip that user. |
10. Click Import 4.1.7+ /data folder.
11, Enter the path to the v4.1.7 <frevvo-home>/data folder that you want to import into this installation.
12. Click Import.
...
.
Things to Check:
- login as a tenant admin
- Click on the Configuration Checklist link to verify that all configurations are complete
- login as a tenant designer user
- view and edit a form/flow
- view submissions that existed before
- test forms/flows
...
If you are running Live Forms for Confluence please follow the same instructions above to upgrade your frevvo form your server. Then you must also install the new version of the Live Forms confluence addConfluence Add-on into your Confluence server. The server and the confluence addConfluence Add-on versions must match.
Database Connector
If you are using the database connector, you must reinstall and configure it again for the v5 .1.1 installation. Version 5 .1.1 includes the latest database connector, version 2.3 beta.