# Database Engine Upgrade

While the ZeeBORN system uses a database engine with long term support and low maintenance requirements, new upgrades may be released from time to time. If an upgrade for the database engine becomes available, you will receive a related notification from ZeeBORN support.

# Preparation

After receiving a notification about a new available database engine upgrade, the following preparation steps need to be planned.

1. Arrange a short maintenance window for your users (max. 10 minutes)
2. Download the upgrade package via the link received from ZeeBORN support.
3. Create a backup of the server where the database engine and the database is hosted.

# Manual Backup of current Database Engine and Databases

If no suitable backup solution is available, it's also possible to create copies of the current database engine and databases without the need of special tools.

The following steps describe the manual backup process:

1. Stop the ZeeBORN database engine service via the Windows Services applet (stop service named "ZeeBORN Database-3306").
2. Create a copy of folder C:\Program Files\ZeeBORN\DBServer
3. Create a copy of folder C:\ProgramData\ZeeBORN\data - if a different folder was selected during the installation of the database engine, please use here the selected folder defined during the installation.

# Installation

1. Extract the upgrade package to a temporary folder. The archive contains the files DBEngineUpgrade.exe and DBEngineUpgrade.pak.
2. After starting the DBEngineUpgrade.exe the installation program will automatically perform a pre-install check.
3. If the pre-install check is passed, the upgrade can be installed by clicking the button Install
4. The upgrade process runs in a separate terminal window opened by the installation program. Depending on the size of the databases, the upgrade process can take several minutes.
5. After the upgrade is finished, the terminal window will show a "Press any key to continue ..." message. After pressing a key, the terminal window closes and returns to the installation application. This can be closed as well.

# Troubleshooting

While it's very unlikely that anything goes wrong with this process, general file storage or hardware problems may prevent the finalization of the upgrade. If a problem occurs, please check in the terminal window if any error message can be found and forward this message to ZeeBORN support.

In case no immediate solution is available, restore the database and database engine from the backup that has been created before starting the upgrade process.