22.3 Upgrade a Version 12 Application to Version 14SP2 or Later

Upgrading a Version 12 Application to V14 SP2 or later is essentially the same as constructing an MSI and installing it. However, an MSI cannot be installed into the same location as an existing V12 application. Doing so will cause an error when installing the MSI.

There are some limitations as described below. Some are issues that need to be dealt with BEFORE even creating your Version Package. Others relate to installing the MSI so that it works correctly.

Before Creating the Application

These same settings must be used as was used to construct the Version 12 Package.

• All Tables must be re-built. This gets all the new features into the CTD for efficient table processing.

• The same Application name.

• The same Partition name

• The same Table Schema (aka File Library in Version 12)

• If you have used separate Packages in Version 12 to install your Application, then consider if you can combine them into one Version. One MSI. That is the easiest way forward. If that's not possible, then consider Feature Set Deployment which allows multiple MSIs to be packaged into a single installation package and then installed into the one directory structure.

Installing MSI

• The database must be upgraded to a version of SQL Server supported by V14SP2 e.g. SQL Server 2008 Express to SQL Server 2017 Express. And you may require an interim step of upgrading SQL Server 2008 to SP4 or later

• A NEW install location is required. You cannot install into the same directory as was used for Version 12.

• The Version 12 shortcuts will left behind on the Windows Desktop and in Start Menu\programs\<application name>