Move Server and Database System

You can move an Allegra installation to another server or change the database system.

Allegra keeps most of its data in a database. Attachments are managed in the TRACKPLUS_HOME directly on the hard disk. To move an installation, follow these steps:

  1. Upgrade your installation to the latest version.

  2. Create a backup of your current Allegra installation (see Data Backup). This will give you a ZIP file located in the TRACKPLUS_HOME/dbbackup directory.

  3. Install Allegra on the target system. You do not need to configure anything in this new installation because all the data will be replaced by the data from the original server.

  4. Follow the instructions for restoring data from a backup file (see Restore Data from a Backup).

  5. Stop the new server and change the entries for the database connection in the file TRACKPLUS_HOME/Torque.properties of the new server so that it points to the database into which you imported the original server data in the previous step.

  6. Restart the new server and change the directories for the attachments, etc., to those that are valid for the new server.

Attention

If you change the database system in the course of this, please note that this can lead to data loss due to the different maximum field lengths of the different systems. A change to MySQL is usually unproblematic, when changing to MS SQLServer and Oracle the text fields should have no more than 4000 characters.