Upgrading HR Manage Server Components (v3.5)

Before starting the updating of the HR Manage server components, it is highly recommended that you create a Rollback Package.

The HR Manage folder structure is usually as follows:

• HRManage
  
  • Backup
  • bin
    • Server
  • Data
  • Setup
    • Client
    • Server
  • Web

Updating the database

The database scripts will usually consist of one or more .sql files.  Each version number has a database script (e.g. "Version 35035.sql").  These files must be executed in version number order, oldest to newest.

To execute a database script, do the following:

• SQL Server 2000
  • Click on Start -> All Programs -> Microsoft SQL Server -> Query Analyzer
  • Log in to the server
  • Click on the File menu and then click Open (Ctrl+Shft+P) and browse for the "Version 35*.sql" file you want to execute and click Open.
• SQL Server 2005/2008
  • Click on Start -> All Programs -> Microsoft SQL Server 2005 / 2008 -> SQL Server Management Studio.
  • Log in to the server
  • Click on the File menu -> Open -> File (Ctrl+O) and browse for the "Version 35*.sql" file you want to execute and click Open.

• On the toolbar, there is a dropdown list.  Click on it and select the HR Manage database.  The database name will usually be HR_CompanyName.
• Press the F5 key OR press the Play button on the toolbar (only once) to execute the script.
• At the bottom, a section will appear with the results of the execution.  Scroll through the results to see if any items are marked in red.  If anything is marked in red, send a copy of the results to us.  This should very rarely happen as we usually do a test upgrade first on our side.
• You can now open the next file and continue to execute the rest of the scripts.  Execute each script ONLY ONCE.

Updating the server application 

We will provide you with a sfx archive containing the updated components.  The filename will be HR_Server_3_5_?_??.exe.  Simply execute it and choose to install it to "?:\HRManage\bin\Server" and overwrite all the files.

You can now go back to the Windows Services console and Start the "HR Manage Server Components" service.

Updating the web components

Delete all the files under the"\HRManage\Web\bin" folder.  In the case of some minor updates, we might advise you to only delete certain files, but that will be explicitly specified in the email.  Now execute the web update file "HR_Web_3_5_?_??.exe and install it to "?:\HRManage\Web" and overwrite all files.

Rolling back from an Rollback Package

To roll back an update, go to your backup files (Rollback Package) and do the tasks in the following order:

• Stop the "HR Manage Server Components" service in the Windows Services console
• Restore the database over the existing database from the backup
• Copy the contents of the bin folder and the bin\Server folder back to ?:\HRManage\bin and overwrite all the files except for "HRManage.Service.exe" and "PeopleResService.exe".
• Delete the contents of ?:\HRManage\Web\bin and then copy the whole Web folder from the rollback package to ?:\HRManage\Web and overwrite all the files
• Start the "HR Manage Server Components" Windows Service again

Online Help - Technical