TM Master V2 – Server Migration Guide

Mark

Updated 11 December 2025 16:05

This guide outlines the full process for migrating TM Master V2 to a new server, including database transfer, file replication, and client reconnection. Follow each step carefully to ensure a smooth transition.

Overview

When replacing the server hosting TM Master V2, the following components must be migrated:

Database → Backup and restore onto a new SQL Server instance
File area → Move data into a new shared folder and update TM Master settings
Software → Install TMv2 client and service, connect them to the restored database

1. Pre-Migration Requirements

Install Required Software

Install Microsoft SQL Server and SQL Server Management Studio (SSMS) on the new server.
Ensure SQL Management Tools are also installed on the old server.
Install the TMv2 client and TMv2 Service on the new server.

Prepare File Area

Create a folder on the new server with the same name as the old server’s data directory (typically TMv2Data).
Share the folder with Everyone – Read/Write permissions.

Database Backup

Create a full backup of the TM Master V2 database on the old server and store the .bak file safely.

2. Migration Steps

1. Agree on Downtime

Schedule a time when the TM Master V2 Service can be stopped.

2. Stop the TM Master V2 Service

Ensure the service is in Sleep Mode before stopping it
(Refer to page 17 of the Technical Guide).

3. Backup the Old Database

Open SSMS →
Right-click the TM Master database →
Tasks → Backup → Create a full .bak file.

4. Move Backup File

Copy the .bak file from the old server to the new server.

5. Restore the Database on the New Server

In SSMS on the new server:
Right-click Databases → Restore Database →
Select the .bak file and complete the restore process.

6. Start TM Master V2 (Client) on the New Server

When prompted with the connection window:

Select or type the SQL Server instance
Enter SQL login username & password
Enter the database name

(See page 5 of the Technical Guide for details.)

7. Copy System File Paths

Copy all system path subfolders from the old file directory into the new shared file area you created earlier.

8. Update File Paths in TM Master

In TM Master:
System → Settings → General

Update:

System File Path
COMM Path

Restart TM Master V2 when prompted.

9. Connect the TM Master V2 Service to the New Database

Run:
TmMv2ServerConnectionTool.exe
(Located in the TM Master V2 Service bin folder)

Click:

Connect to database
Enter the same server/database credentials as above
Click Save → Exit

(See page 11 of the Technical Guide.)

3. Post-Migration Steps

Client Setup

Ensure all clients have the correct TM version installed.

When launching TM Master V2 after migration:

The connection window appears automatically
Select the new server, database, and credentials

TM will create a new connection file located at:

Windows 7 and later
C:\ProgramData\Tero Marine\TM Master v2

Windows XP
C:\Documents and Settings\All Users\Application Data\Tero Marine\TM Master v2

You may copy this XML connection file to other clients to avoid repeating the setup.

Replication (TM Exchange)

If TM Exchange is active, update the COMM path in the exchange settings to reflect the new file location.

Update the following fields:

a. TM Exchange Client → Settings

Default file path
Set this to match the COMM Path under:
System → Settings → General

b. TM Exchange Client → Rules

For each rule:

Update the Path field
Ensure it matches the new COMM Path under:
System → Settings → General