Upgrade TM Master to a new database version

See How to identify the database version article if uncertain which version you have.

NB: Upgrading the office database to a new version can take a lot of time, so we recommend starting these upgrade procedures after office hours to minimize downtime. The bigger your database and the slower your server, the more time the process will take. Vessel databases are typically smaller and take less time to upgrade.

PRELIMINARIES:

1. Distribute the setup files to all vessels before starting upgrade.

2. Back up the TM Master V2 database at office and vessels.

a. Launch the TM Master V2 client.

b. Backup the database ([Fleet -> Database backup] for the office and [Ship ->

Database backup] for the ship). Alternatively - use SQL Management Studio to
perform a database backup.

UPGRADE INSTRUCTIONS:
Important: Make sure all users on the installation you are upgrading (either the office or the ship) have closed down their V2 clients.

1. Upgrade the office first

a. Stop the V2 service manually and close the V2 client if it is running.
b. Upgrade the V2 service on the server by running the SetupUpgradeTMMv2S_*************.exe (only on the server).
c. Upgrade the V2 client (run the upgrade file SetupUpgradeTMMv2_*************.exe).
d. Place the client upgrade file (SetupUpgradeTMMv2_*************.exe) in the
System File Path5 Setup folder: "[System File Path]\Setup"6.
e. Start the V2 client and enter an administrator username and password to upgrade
the database.
f. Start the V2 service

2. Once the office has been upgraded, upgrade the vessels

a. Stop the V2 service manually7 and close the V2 client if it is running.
b. Upgrade the V2 service on the server by running the
SetupUpgradeTMMv2S_*************.exe (only on the server).
c. Upgrade the V2 clients (run the upgrade file
SetupUpgradeTMMv2_*************.exe).
d. Place the client upgrade file (SetupUpgradeTMMv2_*************.exe) in the
System File Path8 Setup folder: "[System File Path]\Setup"9.
e. Start the V2 client and enter an administrator username and password to upgrade
the database.
f. Start the vessel V2 service manually.

NB: It is very important that you start the TM Master V2 client and upgrade the database before you start the service again.

For more, please see the technical guide.