Sahi Pro - Upgrade Sahi Pro

abstract This section describes how to upgrade to Sahi Pro 6.1.0.

danger IMPORTANT INFORMATION on Database Upgrade:
  • H2: On upgrade, Sahi will try to upgrade the database automatically, if you are using H2 db. All existing reports will still be available after upgrade.
    However, it is recommended that you backup userdata/database/ directory if your data is valuable.
  • MySQL: Database has to be upgraded manually. Please refer to Post Upgrade step for MySQL section, for steps to perform after the upgrade.
  • MSSQL: Database has to be upgraded manually. Please refer to Post Upgrade step for MSSQL section, for steps to perform after the upgrade.
  1. Assuming you have Sahi Pro Installed at C:\SahiPro
  2. To download latest version of Sahi Pro Click here
  3. Install the latest version in the same folder where existing Sahi Pro was already installed (C:\SahiPro).
  4. A confirmation window will popup. Click Yes on it.
  5. Complete the installation process

Post Upgrade step for MySQL

MySQL database has to be upgraded manually.

Please follow these instructions.
  1. It is recommended that you take a backup of your database before you perform the manual upgrade, if your data is valuable.
  2. Open config/db/create_report_tables_mysql.sql
  3. You will find sql queries grouped according to version. Copy all queries from versions that are after your current version, to a separate file.
    Examples:
    • If your current version is 6.0.0, copy all queries from /* VERSION 2015-02-09 14:38:51 # 6.1.0 */ onwards.
    • If your current version is 5.1.2, copy all queries from /* VERSION 2014-10-15 18:27:48 # 6.0.0 */ onwards.
  4. Execute the queries copied in the previous step, on your MySQL database.

Post Upgrade step for MSSQL

MSSQL database has to be upgraded manually.

Please follow these instructions.
  1. It is recommended that you take a backup of your database before you perform the manual upgrade, if your data is valuable.
  2. Open config/db/create_report_tables_mssql.sql
  3. You will find sql queries grouped according to version. Copy all queries from versions that are after your current version, to a separate file.
    Examples:
    • If your current version is 6.0.0, copy all queries from /* VERSION 2015-02-09 14:38:51 # 6.1.0 */ onwards.
    • If your current version is 5.1.2, copy all queries from /* VERSION 2014-10-15 18:27:48 # 6.0.0 */ onwards.
  4. Execute the queries copied in the previous step, on your MSSQL database.

Post Upgrade steps for all installations

This section pertains to all types of database installations.
NOTE: Your existing configuration settings will be retained after the upgrade.
However you may need to do the following after an upgrade:

That's it, you have successfully upgraded Sahi Pro!