Guidelines for upgrading Visual LANSA including the SQL Server Instance

Date:18 May 2015
Product/Release:Visual LANSA - All supported versions
Abstract:Considerations and guidelines for migrating from V12 SP1 with SQL Server 2008 to V13 SP2 with SQL Server 2012.
Submitted By:LANSA Technical Support

Users that currently have Visual LANSA V12 SP1, with the shipped SQL Server Express 2008 installed, have 2 migration paths available to get to V13 SP2, which ships with SQL Server Express 2012.

The migration is slightly different depending on whether users wish to

  • upgrade their current Visual LANSA V12 SP1 to V13 SP2
  • or whether users wish to install a separate V13 SP2 and also keep the existing V12 SP1 Visual LANSA environment (side by side).

Note: Both sets of instructions refer to UpgradeSQLServer32.cmd and UpgradeSQLServer46.cmd. These are command files provided by LANSA to assist with the SQL Server instance upgrade. The 32-bit and 64-bit versions of the command files can be downloaded here

Instructions:

If you wish to upgrade from Visual LANSA V12 SP1 (using SQL Server Express 2008) to V13 SP2 (using SQL Server Express 2012), you must upgade your SQL Server 2008 instance to a 2012 instance prior to upgrading Visual LANSA. Use the steps in the attached document to complete the upgrade.

Guidelines for upgrading a development system from V12 with SQL Server 2008 Express to V13 SP2 with SQL Server 2012 Express

If you wish to install a new Visual LANSA V13 SP2 (using SQL Server Express 2012) and also maintain your current V12 SP1 (currently using SQL Server Express 2008), you must upgade your SQL Server 2008 instance to a 2012 instance prior to the V13 SP2 Visual LANSA install. Use the steps in the attached document to complete the upgrade.

Guidelines for installing both V12 SP1 and V13 SP2 development systems using a single SQL Server 2012 Express instance