| Section |
|---|
| Column |
|---|
These steps are required when you convert from a demo/trial server installation to a production installation. | Tip |
|---|
While you are demo-ing you do not need to do the Database Setup steps discussed below. |
Your server requires an SQL database for storing users and form submissions. The following SQL databases have been certified: The server may function with other SQL database types but only the above set has been certified. | Warning |
|---|
- The default HSQLDB is ONLY sufficient for demo/trial versions of . All production users MUST switch their software to a production quality database.
- You cannot migrate the data (user, roles, applications) automatically from HSQL to your production database. See this topic for the manual procedure details.
|
The following steps describe how to change the underlying database from the demo/trial HSQLDB to a production quality SQL database. The database configuration file frevvo.xml is located in <frevvo-home>/frevvo/tomcat/conf/Catalina/localhost directory. |
|
...
It is also appropriate to copy the driver into any location that is in the CLASSPATH of your servlet container. In a tomcat installation another location would be <CATALINA_HOME>/lib.
Transferring Your frevvo Data from HSQL to a Production Database
The bundle includes an HSQL embedded database. If you use the HSQL database during your trial period, You cannot migrate the data (user, roles, applications) automatically from HSQL to your production database. Once your production database is in place, you must manually:
- Create the tenants.
- Use bulk transfer of users to move your users/roles to the tenant.
- Download and upload the applications from designer user accounts in the trial database to the designer users in the new database.