solidDB supports upgrades from at least the two previous release levels; however, conversion of the database files is needed. If you need to upgrade from versions earlier than those supported, you might still be able to convert the database files by converting them to an intermediate version first. For example, you might be able to convert files from version 6 to version 100 and then from version 100 to version 200.
Before you begin, familiarize yourself with the new and changed features that are described in the solidDB Release Notes.
The following steps describe the procedure for upgrading a single solidDB server to a new release level. If you are using solidDB in High Availability mode, see Upgrading (migrating) HotStandby servers.
The previous release level solidDB JDBC and ODBC drivers are compatible with the current release level solidDB server. However, the current versions of the drivers might not be compatible with earlier versions of the server. Thus, the server must be upgraded before the drivers.
If you do not plan to use new features that are introduced in the current release, you do not have to upgrade the drivers.
solidDB is delivered as a single installation file. If you do not want to run the installer on your production environment server, install solidDB on a separate server and copy the executables, libraries, and drivers manually to your production server, as applicable for your setup.
For instructions on how to run the solidDB installer, see Installing solidDB.
4 Update the license file.
Copy the new license file (solid.lic) from the License Certificate image to the solidDB working directory.
If your previous installation used the soliduc.lic license file, you must remove the soliduc.lic file and replace it with the solid.lic license file provided in the solidDB License Certificate.
5 Check the changes in parameter factory values and update the solid.ini configuration files if necessary.
Changes in any parameter values are described in the solidDB Release Notes.
6 Check and update the solidDB JDBC and ODBC driver-related settings as applicable to your environment.
▪ solidDB JDBC driver
If you installed the new solidDB JDBC driver (SolidDriver2.0.jar) into a different location than the previous one, add the new driver location to the CLASSPATH system environmental variable. By default, the solidDB JDBC driver is installed to the jdbc directory in the solidDB installation directory.
▪ solidDB ODBC driver
In Windows and Linux operating systems, define the new ODBC data sources. To use the new driver, you must either modify the existing data sources or create new ones.
If the application links to the solidDB ODBC driver directly, you must recompile your application.
7 Convert the existing database files by starting solidDB with the -x autoconvert or -x convert command-line option.
In the solidDB working directory, run the following command:
solid -x autoconvert
or
solid -x convert
The -x autoconvert option converts the database and starts solidDB.
The -x convert option converts the database and exits solidDB.
After the conversion, you cannot use the database with an earlier version of solidDB. To downgrade a database, you must export and import the data using the solidDB tools.