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 your program.
- Genesis R&D
- The 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 'gendata (#.#.#)' for Genesis or '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 your program.
- 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.
NOTE: If the spaces available to enter the Target Structure Version does not accommodate the value you need to enter, it is likely you have an older version of Database Utility installed. You can download & install an updated version of Database Utility, or contact Support for options.
| Genesis |
Target Structure Version |
Food Processor | Target Structure Version | |
| 11.13.x (Feb 2023) | 11.13.0 |
- |
- | |
| 11.12.x (July 2022) | 11.12.1 |
- |
- | |
| 11.11.x (Oct 2021) | 11.11.0 |
11.11.x (Jan 2022) |
11.11.0 | |
| 11.10.x (Mar 2021) | 11.10.0 |
- |
- | |
| 11.9.x (Nov 2020) | 11.9.0 |
11.9.x (Dec 2020) |
11.9.0 | |
| 11.8.x (June 2020) | 11.8.0 |
- |
- | |
| 11.7.x (June 2019) | 11.7.1 |
11.7.217 (Nov 2019) |
11.7.1 | |
| 11.6.x (Aug 2018) | 11.6.0 |
11.6.x (Oct 2018) |
11.6.0 | |
| 11.5.x (May 2018) | 11.5.1 |
11.5.x (June 2018) |
11.5.0 | |
| 11.4.x (Dec 2017) |
11.4.2 |
11.4.x (Nov 2017) |
11.4.0 | |
| 11.3.x (Feb 2017) | 11.3.4 |
11.3.x (April 2017) |
11.3.2 | |
| 11.2.x (Nov 2016) | 11.2.1 |
11.2.x (Oct 2016) |
11.2.1 | |
| 11.1.x (July 2016) |
11.1.3 |
11.1.x (June 2016) |
11.1.0 | |
|
11.0.x (Aug 2015) |
11.0.3 | 11.0.x (Oct 2015) | 11.0.3 | |
|
9.14.x (Feb 2015) |
9.8.6 | 10.15.x (Feb 2015) | 9.8.3 | |
|
9.13.x (Nov 2014) |
9.7.5 | 10.14.x (Nov 2014) | 9.7.5 | |
|
9.12.x (Jan 2014) |
9.6.0 | 10.13.x (Jan 2014) | 9.6.0 | |
|
9.11.x (Feb 2013) |
9.5.1 | 10.12.x (Feb 2013) | 9.5.1 | |
|
9.10.x (Oct 2012) |
9.4.0 | 10.11.x (July 2012) | 9.4.0 | |
|
9.9.x (May 2012) |
9.3.1 | 10.10.x (May 2012) | 9.3.1 | |
|
9.8.x (Sept 2011) |
9.2.0 | 10.9.x (Sept 2011) | 9.2.0 | |
|
9.7.x (Mar 2011) |
9.1.0 | 10.8.x (Jan 2011) | 9.1.0 | |
|
9.6.x (July 2010) |
9.0.1 | 10.7.x (July 2010) | 9.0.1 | |
|
9.5.x (Mar 2010) |
8.9.2 | 10.6.x (Mar 2010) | 8.9.2 | |
|
9.4.x (Oct 2009) |
8.8.0 | 10.5.x (Oct 2009) | 8.8.0 | |
|
9.3.x (Mar 2009) |
8.7.0 | 10.4.x (Mar 2009) | 8.7.0 | |
|
9.1.x (July 2008) |
8.6.0 | 10.3.x (July 2008) | 8.6.0 | |
|
9.0.x (May 2008) |
8.5.1 | 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