[Optimum] Upgrade database prompted Invalid Column Name 'Receipt'

Created by Cheng Kah Poh, Modified on Wed, 11 Nov, 2020 at 10:14 AM by Cheng Kah Poh

This is due to massive database structure changes across multiple version.

(Upgrading database from below/ older than Version 2015.1.5.8 to current version "latest version")

Solution:
1. Download Version 2015.1.5.8 setup file from below link:

https://drive.google.com/open?id=0BzrrsMUq-H6gbER1VEtjTHlZeVE

2. Update QnE Optimum to Version 2015.1.5.8 and upgrade database to Version 2015.1.5.8.
3. Then you can direct upgrade to current version(latest version)

Please refer How to install Microsoft SQL Management Studio

AND

Please refer How to Connect to Database use Microsoft SQL Server Management Studio