This document is for customers using a full installation of SQL Server 2008 R2 or newer to host the ESHA Database. This assumes a basic understanding of SQL Server Management Studio (SSMS).
- If the Server name includes either "\ESHA", or is literally "(localdb)\v11.0", then it is an ESHA instance of SQL Server, and you will use these instructions.
- If the Server name does not include "\ESHA" or "(localdb)\v11.0", you are using a full installation of SQL Server (non-ESHA instance), and will continue with the instructions below.
Download the script files
If you have not already done so, download and extract the .zip file for The Food Processor
Note: The script file names reflect the starting database structure version, not the ending. For example, "s11.4.0.sql" should be executed against a database structure of 11.4.0. After successful completion, the database structure will update to the next iteration (e.g. 11.4.1).
These scripts must be executed in the correct order for the update to be successful.
Back up your database
- These instructions are meant to step you through backup using SQL Server Management Studio.
Run the scripts
Find your Database Version
- Select the appropriate database for your program. Typically 'eshadata' for Food Processor.
- Click File>New>Query with Current Connection.
- Type the following SQL statement: select * from UDatabaseVersion
- Press F5 to execute the query.
- Note the value in the Structure Version column.
Determine the Starting Script
Once you have found the version numbers for the database, you need to determine which script to run. Generally speaking, run the 's' script that matches the Structure Version you found above. For example, if your structure version is 9.6.0, the script to run is 's9.6.0.sql'. This means that the ending structure version will be higher than the last script you can run.
- After you've backed up the database, use SQL Server Management Studio (SSMS)and Open the correct 's' script determined above.
- Be certain you are connected to the proper database (again, 'eshadata' for Food Processor).
- Execute the script (F5, or click the Execute button on the SSMS ribbon).
- Wait for its completion. If there are any errors, stop and contact support with the Messages output.
- If successful, recheck the Structure Version (follow the Finding your Database Version steps above).
- Repeat until your Structure Version matches the Target Structure Version based on the table below.
|Food Processor (First Release)
||Target DB Structure||
Final Script (*.sql)
|11.11.x (Jan 2022)||11.11.0||s11.9.4|
|11.9.x (Dec 2020)||11.9.0||s11.7.8|
|11.7.x (Nov 2019)||11.7.1||s11.6.3|
|11.6.x (Oct 2018)||11.6.0||s11.5.4|
|11.5.x (June 2018)||11.5.0||s11.4.1|