Upgrade Vaults To a Newer Database Engine

Occasionally, Accruent releases a newer generation of its database engines. Newer versions of Meridian might include small fixes to the database engines and upgrading is normally done as described in Upgrade Meridian Vaults. But large-scale optimizations take longer to develop and test and result in a new generation of engines. When this happens, you might want to upgrade a vault to take advantage of its new features and performance. Upgrading a vault to a new generation of database engine is typically not done during the normal vault upgrade process but must be performed manually.

Note:

An exception is when a vault that uses an older database engine (ObjectSet*.dll, ht3*.dll) is restored onto a 64-bit computer, the database engine is automatically upgraded to the latest database engine (ht5*.dll).

Manually upgrading a vault to a newer database engine can be done by either restoring the vault from a backup or by editing the Windows registry. In both cases, you specify a different database engine for the vault.

The filenames and descriptions of the different database engines are listed in the following table.

Database engine filenames
Filename Description

First generation

ObjectSet.dll

Hypertrieve 32-bit

ObjectSQL.dll

SQL Server 32-bit

ObjectORA.dll

Oracle 32-bit

Second generation

ht3.dll

Optimized Hypertrieve

ht3sql.dll

Optimized SQL Server

ht3ora.dll

Optimized Oracle

Third generation (64-bit only)

ht5.dll

Multi-threaded Hypertrieve

ht5sql.dll

Multi-threaded SQL Server

ht5ora.dll

Multi-threaded Oracle

Note:

This task should only be performed during non-production hours and after a verified backup of the existing vault is made.

ClosedUpgrade during Restore from Backup

To upgrade a vault to a newer database engine during a restore from backup:

  • Follow the procedure for restoring the vault from backup as described in Restore Backups except before running the Restart After Restore From Backup Wizard, edit the datastore.ini file in any text editor and change the value of the DLLName setting to the filename of the database engine that you want the restored vault to use.

ClosedUpgrade by Editing Windows Registry

To upgrade a vault by editing the Windows registry:

  1. Disable and stop the EDM Server service with one of the following methods:

    • The EDM Server properties in Meridian Enterprise Administrator

    • Microsoft Management Console (MMC)

  2. Open the Windows registry and change the value of the DLLName setting described in the following topic to the filename of the database engine that you want the restored vault to use.

    HKEY_LOCAL_MACHINE\Software\Cyco\AutoManager Meridian\CurrentVersion\Installed DataStores\<vaultname>\CompoundItemService

  3. Re-enable and restart the EDM Server service.

2021 R2