Mimer SQL User's Manual PREV

Mimer Developer Site

www.mimer.com/developer


3.1 Upgrading a Mimer SQL Installation


Basically, when upgrading, your application must use the new Mimer SQL shared library, called libmimer.so, and the Mimer SQL database server must be able to locate the new executable programs and the new shared library.

Although it is possible to run Mimer SQL versions in parallel, the most straight forward and recommended solution is to first uninstall the previous version and then install the new version.

You can use the following example in a shell script to check for and uninstall a Mimer SQL installation:

 .
 .
 .
 # Check if Mimer is installed. OK if log file is empty
 INSTALLED='rpm -qa | grep MimerSQL'
 
 if [ ! $INSTALLED = "" ]
 then
      rpm -e $INSTALLED > $LOG 2>&1
      if [ $? -ne 0 ]
      then
         echo "Mimer SQL uninstall failed: rpm -e: `cat $LOG`"
         exit 1
      fi
 fi
 .
 .
 .
Note: This script above checks for and uninstalls Mimer SQL software, it will not affect the Mimer SQL database.

3.1.1 Upgrading a Mimer SQL Database

When upgrading between major releases, for example from 7.3 or 8.1 to 8.2, you have to upgrade existing databases using a database upgrade utility.

To upgrade a Mimer SQL database on Linux, you use the command:

 sdbgen -u database_name
 

From a shell script, you can do as follows:

 .
 .
 .
 # Upgrade a Mimer SQL database
 /usr/bin/sdbgen -u appdb > $LOG 2>&1
 if [ $? -ne 0 ]
 then
     echo "Mimer SQL database upgrade failed: sdbgen: `cat $LOG`"
     exit 1
 fi
 .
 .
 .
 
Caution: Always remember to carry out a proper backup before upgrading a database.

Mimer SQL version 8.2 supports a number of new data types and other features, that can easily be brought into use through the ALTER TABLE statement.

See the Mimer SQL Reference Manual for further information about ALTER TABLE.



Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL User's Manual PREV