Upgrade

Upgrading Therefore™

Information on upgrading Therefore™ can be found in the installation manual:

https://help.therefore.net/tfo/en-us/installation/u_intro.htm

Upgrading Therefore™

Therefore™ Anywhere Migration

Starting with Therefore™ 2026 for On-Premises users and the Therefore™ Online v35 server upgrade for Therefore™ Online users, support of SQL CE 4.0 (SQL Compact) as the offline database used by Therefore™ Anywhere is discontinued. Therefore™ Anywhere now requires SQL Express in order to function. Administrators can find instructions on how to migrate the SQL CE 4.0 database to SQL Express below.

Prerequisites

In order for Therefore™ Anywhere to function, the following components need to be installed on a client PC, meaning a PC where Therefore™ Navigator is running.

• Microsoft SQL Express

  https://www.microsoft.com/en-us/sql-server/sql-server-downloads

• ODBC Driver 18 for SQL Server

  https://learn.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server

• Users who want to migrate an existing database also have to download a zip archive named Therefore™ Anywhere Upgrade Kit from the Therefore™ Extranet. The script includes a utility and a script.

  https://extranet.therefore.net/downloads/therefore-setup/

As in previous versions of Therefore™, only Named Users for which the option 'Work Offline' has been checked can use Therefore™ Anywhere and take documents offline. This option can be found by right-clicking on the Therefore™ root object > selecting 'License' > 'Named Users' tab > checking the checkbox in the column labeled 'Work Offline'.

Creating a New Offline Database

This option is for users who want to use Therefore™ Anywhere with a new offline database instead of migrating an existing one.

Once the prerequisites are fulfilled, the creation of a new offline database can be done in the same way as in older versions of Therefore™, namely by right-clicking on a Therefore™ document or case definition in the Therefore™ Navigator hit-list and selecting the option 'Make Available Offline'.

Migrating an Existing Offline Database

This option is for users who want to use Therefore™ Anywhere with a an existing offline database.

To keep using the old offline database it needs to be migrated from SQL CE 4.0 to SQL Express.

• Unpack the Therefore™ Anywhere Upgrade Kit zip archive and save the 'ExportSqlCe40.exe' utility to the client PC.

• Copy the PowerShell script 'AnywhereUpdate.ps1' from the kit to the same folder as 'ExportSqlCe40.exe'.

• Run the script 'AnywhereUpdate.ps1' with administrator privileges.

• While running the script, enter the SQL Express instance name to which the offline database will be migrated. By default this is '.\SQLEXPRESS'.

• Running the script creates a logfile called 'export_log.txt' where the process can be reviewed.

After running the script, the options related to Therefore™ Anywhere - Synchronization tab, 'Work Offline/Connect to Server' - should be visible in the UI again.