This document is for any customer using Database Utility to update the ESHA Database. This is the most common installation. If you're not sure this is you, note the Server name listed in an error message or in the program itself. You can find your Server name in the program on the Home ribbon by clicking About. (If you have an older version go to the Help menu and select About.)
- 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). For updating the database under full SQL Server, refer to this article regarding the use of SQL Server Management Studio.
To update your database:
Download and extract the correct .zip file containing the most up-to-date scripts for Food Processor.
- Start Database Utility. If you have Windows 7, 8, 8.1, Windows 2008 Server R2, or Server 2012, you may need to right-click and Run As Administrator.
- In the "Connect to server..." dialog, choose your Server name. You can find your Server name in the program on the Home ribbon by clicking About. (If you have an older version go to the Help menu and select About.)
- In Database Utility, make sure you have the proper database selected from the drop-down on the toolbar. Likely 'eshadata (#.#.#)' for The Food Processor.
- Click Database > Backup. Proceed to backup the database before continuing.
- Click Database > Update.
-
As noted above, download and extract the correct .zip file containing the most up-to-date scripts for The Food Processor
- Click browse and navigate to the folder in which the script files were extracted.
- For 'Target Structure Version:', enter the appropriate ending structure version based on the table below:
| Food Processor | Target Structure Version |
|
11.14.x (Oct 2023) |
11.14.0 |
|
11.11.x (Jan 2022) |
11.11.0 |
|
11.9.x (Dec 2020) |
11.9.0 |
|
11.7.217 (Nov 2019) |
11.7.1 |
|
11.6.x (Oct 2018) |
11.6.0 |
|
11.5.x (June 2018) |
11.5.0 |
|
11.4.x (Nov 2017) |
11.4.0 |
|
11.3.x (April 2017) |
11.3.2 |
|
11.2.x (Oct 2016) |
11.2.1 |
|
11.1.x (June 2016) |
11.1.0 |
| 11.0.x (Oct 2015) | 11.0.3 |
| 10.15.x (Feb 2015) | 9.8.3 |
| 10.14.x (Nov 2014) | 9.7.5 |
| 10.13.x (Jan 2014) | 9.6.0 |
| 10.12.x (Feb 2013) | 9.5.1 |
| 10.11.x (July 2012) | 9.4.0 |
| 10.10.x (May 2012) | 9.3.1 |
| 10.9.x (Sept 2011) | 9.2.0 |
| 10.8.x (Jan 2011) | 9.1.0 |
| 10.7.x (July 2010) | 9.0.1 |
| 10.6.x (Mar 2010) | 8.9.2 |
| 10.5.x (Oct 2009) | 8.8.0 |
| 10.4.x (Mar 2009) | 8.7.0 |
| 10.3.x (July 2008) | 8.6.0 |
| 10.2.x (May 2008) | 8.5.1 |
| 10.1.x (July 2007) | 8.4.5 |
| 10.0.x (Jan 2007) | 8.3.5 |
9. Click Update.
Comments
0 comments
Please sign in to leave a comment.