Follow

Manually updating the ESHA Database (full SQL Server)

This document is for customers using a full installation of SQL Server 2005 or newer to host the ESHA Database.

If unsure, note the Server name listed in an error message, or in the program itself.  You can find your Server name in the program under 'Home / About', or possibly on the menu under 'Help / About' or 'Help / Information'.  If the Server name includes either "\ESHA", or is literally "(localdb)\v11.0", then it is an ESHA instance of SQL Server.  If you are using an ESHA instance to host the database, refer to ESHA-installed instance of SQL Server (using Database Utility).

1. Download and extract the correct .zip file containing the most up-to-date scripts for your program.

 Note: The script file names are the starting structure version, not ending. s9.8.4.sql runs when the structure version is 9.8.4, and after it runs, the database will be at structure version 11.0.0  

These scripts must be executed in the correct order for the update to be successful.

2. Backup your database before running the scripts.
3. Find your Database Version
  1. Select the appropriate database ('eshadata' or 'gendata').
  2. Click File/New/Query with Current Connection.
  3. Type the following SQL statement:  select * from UDatabaseVersion
  4. Press F5 to execute the query.
  5. Note the Structure Version.
4. Determine Starting Script & Execute It - Once you have found the version numbers for the database, you need to determine which script you need to run. Generally speaking, run the 's' script that matches your Structure Version found in #3 above. For example, if your structure version is 8.4.0, the script to run is 's8.4.0.sql'. This means that the ending structure version will be higher than the last script you run, for example script s9.8.4 takes the database to structure version 11.0.0. To execute a script in Management Studio:
  • Follow steps '3(1)' and '3(2)' above to open a query window.
  • Then click File/Open/File.
  • Open the appropriate script.
  • Connect if necessary.
  • In the Available Databases window (on toolbar), select the proper database ('eshadata' or 'gendata').
  • Press F5 to execute.
5. Repeat steps 3 & 4 above until your Structure Version matches the Target Structure Version based on the table below.
 
NOTE: Recheck the database version after running each script. The scripts do not necessarily take you to the next row in the update table. And remember the script number is the starting structure version, not the ending structure version.
 
Genesis
(First Release Date)
Target DB Structure Final Script  Number Food Processor
(First Release Date)
Target DB Structure Final Script Number

-

- - 11.4.x (11/3/17) 11.4.0 s11.3.2

11.3.x (2/15/2017)

11.3.4 s11.3.3 11.3.x (4/12/17) 11.3.2 s11.3.1

11.2.x (11/28/2016)

11.2.1 s11.1.3 11.2.x (10/5/16) 11.2.1 s11.2.0

11.1.x (7/14/2016)

11.1.3 s11.1.2 11.1.x (6/6/16) 11.1.0 s11.0.3
11.0.x (8/6/15) 11.0.0 s9.8.4 11.0.x (10/14/15) 11.0.2 s9.8.6

9.14.x (2/11/15)

9.8.3 s9.8.2 10.15.x (2/11/15) 9.8.3 s9.8.2

9.13.x (11/20/14)

9.7.5 s9.7.4 10.14.x (11/20/14) 9.7.5 s9.7.4

9.12.x (1/31/14)

9.6.0 s9.5.1 10.13.x (1/31/14) 9.6.0 s9.5.1

9.11.x (2/28/13)

9.5.1 s9.5.0 10.12.x (2/14/13) 9.5.1 s9.5.0

9.10.x (10/31/12)

9.4.0 s9.3.1 10.11.x (7/20/12) 9.4.0 s9.3.1

9.9.x (5/25/12)

9.3.1 9.3.0 10.10.x (5/29/12) 9.3.1 s9.3.0

9.8.x (9/21/11)

9.2.0 s9.1.0 10.9.x (9/21/11) 9.2.0 s9.1.0

9.7.x (3/23/11)

9.1.0 s9.0.1 10.8.x (1/20/11) 9.1.0 s9.0.1

9.6.x (7/27/10)

9.0.1 s9.0.0 10.7.x (7/27/10) 9.0.1 s9.0.0

9.5.x (3/19/10)

8.9.2 s8.9.1 10.6.x (3/31/10) 8.9.2 s8.9.1

9.4.x (10/7/09)

8.8.0 s8.7.0 10.5.x (10/7/09) 8.8.0 s8.7.0

9.3.x (3/2/09)

8.7.0 s8.6.1 10.4.x (3/2/09) 8.7.0 s8.6.1

9.1.x (7/24/08)

8.6.0 s8.5.1 10.3.x (7/11/08) 8.6.0 s8.5.1

9.0.x (5/9/08)

8.5.1 s8.5.0 10.2.x (5/9/08) 8.5.1 s8.5.0

 

    10.1.x (7/9/07) 8.4.5 s8.4.4

 

    10.0.x (1/2/07) 8.3.5 s8.3.4
 
 
 
Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request

Comments

  • Avatar
    Brant Strand

    This article seems to be only valid for FP up to 9.8.0, as that is the latest version in the attached SQL scripts zip. Is there an updated version available?

  • Avatar
    Patrick Murphy

    As of this writing, the Structure Version for Food Processor is 9.8.x, however the Structure Versions is different than the Program Version. Food Processor program version 10.15.x requires a (Database) structure version of 9.8.x. Food Processor 10.15.x is the most updated version of the software, released in February 2015.

Powered by Zendesk