Forcing A Version Downgrade

In very rare cases it may be necessary to force a version downgrade, for example installing an incompatible version of ProCal.

Version checking only takes place in Version 6 of software onward.

These instructions assume that you have SQL Server Management Studio installed.

1. Using SQL Server Management Studio (referred to a SSMS throughout the rest of these instructions) connect to your ProCal SQL Server Instance. Typically, this will be in the format [ServerComputerName]/TRANSMILLE (assuming that the default Instance name has been used). You will need a valid username and password.
2. In the navigation Pane on the left, click the small + next to databases and then click the + next to ProCal.
   
   

3. Click + next to tables and then navigate to dbo.Software_Versions - Please note that the tables on your database will vary depending upon the version as well as any customized trigger tables.
   
   

4. Right Click on dbo.Software_Version and select 'Edit Top 200 Rows'.
   

5. Select the Software that needs downgrading, in this example we are selecting ProCal, and downgrading from 6.5.14 to 6.5.10.

6. Edit the appropriate column, in this example we are editing the 'Minor_Revision' Column. Type the new number into the table Note that the text in the bottom of the window updates to 'Cell Is Modified' and the left most column updates to a picture of a pen.
   

   
   

7. Using the arrow keys, navigate up or down (whatever is possible) to a new row. The data is now saved. Make sure that a new cell is selected otherwise the data will not be saved.

8. Close SSMS.

9. Place the old ..exe files in either your local folder (for single users) or in your system updates folder and make sure that all users of the system copy the new .exe files across to their computer.

10. If any computer with a newer version re-connects the software table will be updated again.