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.
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.
| 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 |
This task should only be performed during non-production hours and after a verified backup of the existing vault is made.
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.
To upgrade a vault by editing the Windows registry:
-
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)
-
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.
- Re-enable and restart the EDM Server service.
