About Previous Mimer SQL Versions

---

This chapter describes how to upgrade from earlier versions of Mimer SQL.

For information about packaging in earlier versions of Mimer SQL, please refer to the corresponding version of Mimer Packaging Guide.

On Windows, Mimer does not support parallel installations of different versions of Mimer SQL. In the following sections, the term components refers to items such as the database server, database client, and online documentation.

4.1 Upgrading a Mimer SQL Installation

The logic used by the installation program is as follows:

• If the new installation is a change of major version, for example from version 8.2 to 9.3, the install script asks the user whether they want to uninstall the old version and install the new. If a silent install is carried out, the installation proceeds without asking.
• Only the components selected by the silent setup are installed.
• If the new installation is a change of minor version, for example from version 9.3.7 to 9.3.8, the system will run a maintenance setup and install all the components that were previously installed, plus any additional components selected by the silent setup.

  This method of upgrading means that the installation program does not know where the installation directory is.

• If the version to be installed is older than the version already installed (such as 9.3.8 installed and trying to install 9.3.6), the installation fails. To do this, the user must first uninstall the already installed version and then redo the installation of the older version.

4.2 Upgrading a Mimer SQL Database

When upgrading between major versions, for example from 8.2 or 9.1 to 9.3, existing databases must be upgraded using a database upgrade utility.

The interactive method of upgrading Mimer SQL databases is by using the Mimer Administrator. Upgrade is one of the menu alternatives when right-clicking a local database.

You can also upgrade a database from a program using the ODBC routine SQLConfigDataSource.

The following C example will upgrade the MyLocalMimer database where the system administrator password is SYSPSW:

 rc = SQLConfigDataSource(NULL,ODBC_CONFIG_SYS_DSN,"MIMER",
      "DATABASE=MyLocalMimer\0"
      "UPGRADE=-pSYSPSW MyLocalMimer\0\0");
 

Always remember to carry out a proper backup before upgrading a database.

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

Mimer Information Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 info@mimer.se