...

   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 , 0

4.8 → 5.0 → 6.0  , 40

4.8.2 → 5.0 →6.0 , 40

4.8.1.2 →5.0 → 6.0  , 50

5.0 →6.0  , 5.0.1 → 6.0  ,0

5.0.2 → 6.0 ,5.0.3 → 6.0  ,0

5.1 → 6.0 ,

5.1.1 → 6.0 ,

5.1.2 → 6.0 .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

1. 
   
   1. Install 5.0 in MYSQL db 
   2. Upgrade 4.7 to 5.0 in MYSQL db 
   3. Take backup from 5.0 in MYSQL db
   4. Install 5.0 in MSSQL db 
   5. Restore backup taken from 5.0(MYSQL) to 5.0(MSSQL)
   6. Upgrade 5.0(MSSQL) to 6.0 (MSSQL).

     Scenario 2: From 4.8 SQL Server to 6.0 SQL Server    

1. 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    

1. 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    

1. 
   
   1. Install 5.0 in MYSQL db 
   2. Upgrade 4.8.1.2(MySQL) to 5.0 in MYSQL db 
   3. Take backup from 5.0 in MYSQL db
   4. Install 5.0 in MSSQL db 
   5. Restore backup taken from 5.0(MYSQL) to 5.0(MSSQL)
   6. Upgrade 5.0(MSSQL) to 6.0 (MSSQL).

     Scenario 5: From 5.0 MySQL to 6.0 SQL Server

1. Install 5.0 in MySQL db  → Create data.
2. Restore backup taken from 5.0(MYSQL) to 5.0(MSSQL)
3. Upgrade 5.0(MSSQL) to 6.0 (MSSQL)

       
   Scenario Scenario 6: From 5.0.1 MySQL to 6.0 SQL Server

1. Install 5.0.1 in MySQL db  → Create data.
2. Restore backup taken from 5.0.1(MYSQL) to 5.0.1(MSSQL)
3. Upgrade 5.0(MSSQL) to 6.0 (MSSQL).

   
  Scenario Scenario 7: From 5.0.2 MySQL to 6.0 SQL Server

...

1. DIrect Upgrade from 5.0.3 → 6.0

...

Scenario 9 : From 5.1 SQL Server to 6.0 SQL Server  

1. DIrect Upgrade from 5.1 → 6.0

 
Scenario 10 : From 5.1.1 SQL Server to 6.0 SQL Server
 

1. DIrect Upgrade from 5.1.1 → 6.0

 
Scenario 11 : From 5.1.2 SQL Server to 6.0 SQL Server
 

1. 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

1. 
   
   1. Install 5.0 in MYSQL db 
   2. Upgrade 4.8.1.2(MySQL) to 5.0 in MYSQL db 
   3. Take backup from 5.0 in MYSQL db
   4. Install 5.0 in Oracle db 
   5. Restore backup taken from 5.0(MYSQL) to 5.0(Oracle)
   6. 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

1. Copy Zephyr data some where then follow below steps.
2. Uninstall 4.8_13842 using below command.(Uninstall by skiping DB drop)

...

1. In DB → Select User for runing Query (i.e → ALTER SESSION SET current_schema ="ITCC"
2. Now after selecting Current User run these queries → LG_Oracle_dashboard_index_issue.sql
3. 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 Direct Upgrade From 5.01.3 → 61 → 6.0 

Scenario 7 : From 5.1 Oracle to 6.0 Oracle

DIrect Direct Upgrade From 5.1.1 → 6→ 6.0 

Scenario 8 : From 5.0.3 Oracle to 6.0 Oracle

DIrect Direct Upgrade From 5.1.1 → 6.0 
 

Scenario 9: From 5.0.3 Oracle to 6.0 Oracle

 
DIrect Direct Upgrade From 5.1.2 1 → 6.0 
Upgrade for Linux
Image Removed

...