Upgrade to 6.0
This section applies specifically to the Zephyr Enterprise product and provides instructions on upgrading the Zephyr Enterprise instance. The information below is generally used to ensure that system administrators can upgrade and update their Zephyr Enterprise product instance.
The information and links below provide an in-depth knowledge and step-by-step guide to assist your system administrator with upgrading Zephyr Enterprise from an earlier version to a 6.0 instance.
Best Practice Before Upgrading
As a best practice before upgrading, we strongly recommend performing a backup of your database to ensure data integrity and to make the upgrade as seamless as possible during the transition.
Database backups are extremely ideal when you are upgrading your Zephyr instance to retain your data if any issues occur during the upgrade process.
For any upgrade, ensure that a database backup is performed.
Please navigate through the links below that best describe your preferred upgrade environment.
Table of Contents
Guidelines
After Upgrade is done before starting the server and all connections to database should be terminated
In Cluster environment all other nodes should be down
Upgrader from command | |
MySQL Upgrader command for windows | <upgrader file name> -VzMySQLPath='C:\Program Files\MySQL\MySQL Server 5.6\bin\mysql.exe' -VzMySQLCnfFilePath='C:\Program Files\MySQL\MySQL Server 5.6\my-default.ini' |
MySQL upgrader command for Linux | <upgrader file name> -VzMySQLPath='/usr/bin/mysql' -VzMySQLCnfFilePath='/etc/mysql/my.cnf' |
Embedded Upgrader command | <upgrader file name> -VzMySQLPath='C:\Program Files\Zephyr\mysql\bin\mysql.exe' -VzMySQLCnfFilePath='C:\Program Files\Zephyr\mysql\my.ini' |
For MSSQL Upgrader | For windows double click & For linux sh <upgrader file name>.sh (No need to pass any arguments like MySQL) |
For Oracle Upgrader | For windows double click & For linux sh <upgrader file name>.sh (No need to pass any arguments like MySQL) |
-------------------------------------------------------------------------------------------------------------------------
1. Mysql : 4.7 → 5.0 → 6.0 , 4.8 → 5.0 → 6.0 , 4.8.2 → 5.0 → 6.0, 4.8.1.2 →5.0 → 6.0 ,5.0 → 6.0 , 5.0.1 → 6.0 ,5.0.2 → 6.0 ,5.0.3 → 6.0 ,5.1 → 6.0 ,5.1.1 → 6.0 ,5.1.2 → 6.0 .
Scenario 1:
Upgrade 4.7 to 5.0 in MySQL db → Upgrade from 5.0 → 6.0.
Scenario 2:
Upgrade 4.8 to 5.0 in MySQL db → Upgrade from 5.0 → 6.0.
Scenario 3:
Upgrade 4.8.2 to 5.0 in MySQL db → Upgrade from 5.0 → 6.0.
Scenario 4:
Upgrade 4.8.1.2 to 5.0 in MySQL db → Upgrade from 5.0 → 6.0.
Scenario 5:
1. Upgrade from 5.0 → 6.0.
Scenario 6:
1. Upgrade from 5.0.1 → 6.0.
Scenario 7:
1. Upgrade from 5.0.2 → 6.0.
Scenario 8:
1. Upgrade from 5.0.3 → 6.0.
Scenario 9:
1. Upgrade from 5.1 → 6.0.
Scenario 10:
1. Upgrade from 5.1.1 → 6.0.
Scenario 11:
1. Upgrade from 5.1.2 → 6.0.
2. Sql Server:
4.7 → 5.0 → 6.0
4.8 → 5.0 → 6.0
4.8.2 → 5.0 →6.0
4.8.1.2 →5.0 → 6.0
5.0 →6.0 , 5.0.1 → 6.0
5.0.2 → 6.0 ,5.0.3 → 6.0
5.1 → 6.0
5.1.1 → 6.0
5.1.2 → 6.0
4.7/4.8.1.2 to 5.0(MSSQL) direct upgrade is not possible.
Since we don't have upgrader for that.
Following steps to be followed for MSSQL DB Migration.
Scenario 1: From 4.7 (MySQL) to 5.1 SQL Server
Install 5.0 in MYSQL db
Upgrade 4.7 to 5.0 in MYSQL db
Take backup from 5.0 in MYSQL db
Install 5.0 in MSSQL db
Restore backup taken from 5.0(MYSQL) to 5.0(MSSQL)
Upgrade 5.0(MSSQL) to 6.0 (MSSQL).
Scenario 2: From 4.8 SQL Server to 6.0 SQL Server
4.8 → 4.8.2 restore + 4.8.2 → 5.0 Upgrade → 6.0 Upgrade
Scenario 3: From 4.8.2 SQL Server to 6.0 SQL Server
Upgrade 4.8.2 to 5.0 in SQL Server db → 6.0 Upgrade
Scenario 4: From 4.8.1.2 to 6.0 SQL Server
Install 5.0 in MYSQL db
Upgrade 4.8.1.2(MySQL) to 5.0 in MYSQL db
Take backup from 5.0 in MYSQL db
Install 5.0 in MSSQL db
Restore backup taken from 5.0(MYSQL) to 5.0(MSSQL)
Upgrade 5.0(MSSQL) to 6.0 (MSSQL).
Scenario 5: From 5.0 MySQL to 6.0 SQL Server
Install 5.0 in MySQL db → Create data.
Restore backup taken from 5.0(MYSQL) to 5.0(MSSQL)
Upgrade 5.0(MSSQL) to 6.0 (MSSQL)
Scenario 6: From 5.0.1 MySQL to 6.0 SQL Server
Install 5.0.1 in MySQL db → Create data.
Restore backup taken from 5.0.1(MYSQL) to 5.0.1(MSSQL)
Upgrade 5.0(MSSQL) to 6.0 (MSSQL).
Scenario 7: From 5.0.2 MySQL to 6.0 SQL Server
Install 5.0.2 in MySQL db → Create data.
Restore backup taken from 5.0.2(MYSQL) to 5.0.2(MSSQL)
Upgrade 5.0.2(MSSQL) to 6.0 (MSSQL).
Scenario 8 : From 5.0.3 SQL Server to 6.0 SQL Server
DIrect Upgrade from 5.0.3 → 6.0
Scenario 9 : From 5.1 SQL Server to 6.0 SQL Server
DIrect Upgrade from 5.1 → 6.0
Scenario 10 : From 5.1.1 SQL Server to 6.0 SQL Server
DIrect Upgrade from 5.1.1 → 6.0
Scenario 11 : From 5.1.2 SQL Server to 6.0 SQL Server
DIrect Upgrade from 5.1.2 → 6.0
Command used for restore: Linux: ./restoreAll.sh -FORCE Windows: restoreAll.bat -FORCE
3. Oracle 11G: 4.8.1.2 →6.0
Scenario 1: From 4.8.1.2 MySQL to 6.0 Oracle
Install 5.0 in MYSQL db
Upgrade 4.8.1.2(MySQL) to 5.0 in MYSQL db
Take backup from 5.0 in MYSQL db
Install 5.0 in Oracle db
Restore backup taken from 5.0(MYSQL) to 5.0(Oracle)
Upgrade 5.0 (Oracle) to 6.0 (Oracle).
Command used for restore:
Linux: ./restoreAll.sh -FORCE Windows: restoreAll.bat -FORCE
Scenario 2: From 4.8.1.2 Oracle to 6.0 Oracle
Copy Zephyr data some where then follow below steps.
Uninstall 4.8_13842 using below command.(Uninstall by skiping DB drop)
sh <zephyr_installation_directory>/ZephyrUninstaller -c -VzSkipDropData=true
Run below command to install 5.0/5.0.1, when asked to enter DB user provide custom DB user details created.
sh zephyr_5.0_14667_setup_iRev_2012.sh -VzAllowOtherOracleUser=true -VzSkipStartupData=true -
VzSkipDropData=true -VzSkipZephyrSeverStart=true
Upgrade 5.0/5.0.1 by running below command.
sh zephyr_5.0_14667_upgrader_iRev_2012.sh -c -VskipBackupFile=true -VskipRestore=true -
VzSkipVersionCompatibilityCheck=true -VbackupFileVersion=13842
Migrate attachment by manually copying attachment folder backup taken from production to
<zephyr_5.0_14667_installation_dir>/zephyrdata/attachment
In DB → Select User for runing Query (i.e → ALTER SESSION SET current_schema ="ITCC"
Now after selecting Current User run these queries → LG_Oracle_dashboard_index_issue.sql
Now Run 6.0 installer and select Upgrade mode .
Scenario 3: From 5.0 MySQL to 6.0 Oracle
Install 5.0 in MySQL db → Create data. Restore backup taken from 5.0(MYSQL) to 5.0(Oracle) Upgrade 5.0(Oracle) to 6.0 (Oracle).
Scenario 4: From 5.0.1 MySQL to 6.0 Oracle
Install 5.0.1 in MySQL db → Create data. Restore backup taken from 5.0.1(MYSQL) to 5.0.1(Oracle) Upgrade 5.0.1(Oracle) to 6.0 (Oracle).
Scenario 5 : From 5.0.2 MySQL to 6.0 Oracle
Install 5.0.2 in MySQL db → Create data. Restore backup taken from 5.0.2(MYSQL) to 5.0.2(Oracle) Upgrade 5.0.2(Oracle) to 6.0 (Oracle).
Scenario 6 : From 5.0.3 Oracle to 6.0 Oracle
Direct Upgrade From 5.1.1 → 6.0
Scenario 7 : From 5.1 Oracle to 6.0 Oracle
Direct Upgrade From 5.1.1 → 6.0
Scenario 8 : From 5.0.3 Oracle to 6.0 Oracle
Direct Upgrade From 5.1.1 → 6.0
Scenario 9: From 5.0.3 Oracle to 6.0 Oracle
Direct Upgrade From 5.1.1 → 6.0