Migrating

You are here: Migrating
4.0 Migrating

This procedure assumes that you are updating Moab Accounting Manager to a new major or minor release where there are database schema changes. Instructions for upgrading to a new maintenance or fix release where there are no database schema changes can be found in 3.0 Upgrading.

The instructions in this chapter demonstrate the process of migrating a database schema from Moab Accounting Manager 7.0 to 7.1 or from Gold Allocation Manager 2.2 to Moab Accounting Manager 7.1. By default, this version will unpack into a separate directory (/opt/mam) which, after modifying the database and port of the prior installation, will allow us to run or access both versions simultaneously. You can determine your current database version by running 'goldsh System Query'.

If you are migrating from a version of Gold Allocation manager prior to version 2.2, you will first need to perform a migration install to Gold Allocation Manager 2.2 using the Gold Allocation Manager tarball and the associated migration script and procedures.

SQLite databases cannot yet be migrated in most circumstances since current versions do not support the ALTER TABLE ADD COLUMN syntax.

This chapter provides a number of sample steps referenced to a particular installation on a Linux platform using the bash shell. These steps indicate the userid in brackets performing the step. The exact commands to be performed and the user that issues them will vary based on the platform, shell, installation preferences, etc. These steps are very similar to the steps for performing a maintenance or fix upgrade install with the exception that the migration scripts should be run after restarting the server after the make install.

4.0 Migrating