Upgrade Step | MySQL | Oracle | Notes |
|---|
2.6.0 | sakai_2_6_0_mysql_conversion.sql | sakai_2_6_0_oracle_conversion.sql | Use scripts updated in 2.6.x branch (r65964+). Include fixes for , and . If you are upgrading from 2.5 please review | Jira Legacy |
|---|
| server | SakaiSystem JIRA |
|---|
| serverId | 66e9c5b597e0cfea-d22cfe72-30a2310f-a9d4a179-703f4354570c8363adfc350a |
|---|
| key | SAK-15597 |
|---|
|
for an important property setting issue (not a database conversion issue). |
2.6.0 to 2.6.x | sakai_2_6_0-2_6_x_mysql_conversion001_SAK-16668.sql | sakai_2_6_0-2_6_x_oracle_conversion001_SAK-16668.sql | : if you upgraded to Sakai 2.6.0 PRIOR to 1 Sept 2009 you must run this conversion to update data types in ASN_MA_ITEM_T and ASN_NOTE_ITEM_T. |
2.6.0 to 2.6.x | sakai_2_6_0-2_6_x_mysql_conversion002_SAK-16548.sql | sakai_2_6_0-2_6_x_oracle_conversion002_SAK-16548.sql | , : Matt Jones (UMich) reports that the original 2.6.0 to 2.6.1 conversion script for the assignment_content table "is inefficient, potentially locks tables and performs too many scans, especially if there are hundreds of thousands of rows." Matt has revised both the MySQL and Oracle conversion scripts to improve their performance. |
2.6.0 to 2.6.x | sakai_2_6_0-2_6_x_mysql_conversion003_SAK-16847.sql | sakai_2_6_0-2_6_x_oracle_conversion003_SAK-16847.sql | : adds asn.share.drafts to SAKAI_REALM_FUNCTION. |
2.6.0 to 2.6.x | sakai_2_6_0-2_6_x_mysql_conversion004_SAK-10512.sql | sakai_2_6_0-2_6_x_oracle_conversion004_SAK-10512.sql | : updates existing entries in SAKAI_PERSON_T setting the field locked to false if currently NULL. |
2.6.0 to 2.6.1 | sakai_2_6_0-2_6_1_mysql_conversion.sql | sakai_2_6_0-2_6_1_oracle_conversion.sql | Rollup of 2.6.0-2.6.x conversion scripts 001-004 above. |
2.6.1 to 2.6.2 |
|
| no schema changes |
2.6.0 to 2.6.x | sakai_2_6_0-2_6_x_mysql_conversion005_SAK-14482.sql | sakai_2_6_0-2_6_x_oracle_conversion005_SAK-14482.sql | : replace the "mercury" site's sakai.assignment tool (deprecated since 2.5.0) with the sakai.assignment.grades tool. |
2.6.2-2.7.0 | sakai_2_7_0_mysql_conversion.sql | sakai_2_7_0_oracle_conversion.sql |
|
2.7.0-2.7.1 | sakai_2_7_0-2_7_1_mysql_conversion.sql | sakai_2_7_0-2_7_1_oracle_conversion.sql |
|
2.7.1-2.7.2 | sakai_2_7_1-2_7_2_mysql_conversion.sql | sakai_2_7_1-2_7_2_oracle_conversion.sql |
|
2.8.0 | sakai_2_8_0_mysql_conversion.sql | sakai_2_8_0_oracle_conversion.sql | 2.7.1 to 2.8.0 database conversion. |
2.8.0 | sakai_2_8_0_mysql_hbm_indexes.sql | sakai_2_8_0_oracle_hbm_indexes.sql | Starting up sakai-2.8.0 in order to populate an empty database (auto.ddl=true) can result in certain tools relying on Hibernate 3.2.7.ga to generate indexes to fail to do so. Check database and then run this script to add missing indexes. |
| 2.8.1 | sakai_2_8_0-2_8_1_mysql_conversion.sql | sakai_2_8_0-2_8_1_oracle_conversion.sql | Conversion from 2.8.0 to 2.8.1 can result in lost mail messages. See | Jira Legacy |
|---|
| server | SakaiSystem JIRA |
|---|
| serverId | 66e9c5b597e0cfea-d22cfe72-30a2310f-a9d4a179-703f4354570c8363adfc350a |
|---|
| key | SAK-21305 |
|---|
|
for details on how to fix.This should only affect cases for which 2.8.0 was actually RUN in production, not if 2.8.0 is just one step in your upgrade process. |
| 2.8.2 | sakai_2_8_1-2_8_2_mysql_conversion.sql | sakai_2_8_1-2_8_2_oracle_conversion.sql |
|
| 2.8.3 | sakai_2_8_2-2_8_3_mysql_conversion.sql | sakai_2_8_2-2_8_3_oracle_conversion.sql |
|
| 2.9.0 | sakai_2_9_0_mysql_conversion.sql | sakai_2_9_0_oracle_conversion.sql | For languages other than English, Catalan and Spanish please see | Jira Legacy |
|---|
| server | SakaiSystem JIRA |
|---|
| serverId | 66e9c5b597e0cfea-d22cfe72-30a2310f-a9d4a179-703f4354570c8363adfc350a |
|---|
| key | SAM-787 |
|---|
|
. |
| 2.9.1 | sakai_2_9_1_mysql_conversion.sql | sakai_2_9_1_oracle_conversion.sql
|
|
| 2.9.2 | sakai_2_9_2_mysql.sql LTI 2_1_0_mysql_conversion.sql
| sakai_2_9_2_oracle.sql LTI_2_1_0_oracle_conversion.sql |
|
| 2.9.3 | sakai_2_9_3_mysql.sql
| sakai_2_9_3_oracle.sql |
|
| 10.0 | sakai_10_mysql.sql | sakai_10_oracle.sql | Please note, the Oracle conversion scripts should be taken from trunk at the moment, including for the conversion to 10.0 - Neal Caidin - 14-October-2014 |
| 10.1 | sakai_10_0-10_1_mysql_conversion.sql | sakai_10_0-10_1_oracle_conversion.sql |
|
| 10.2 | no conversion needed for MySql | sakai_10_1-10_2_oracle_conversion.sql |
|
| 10.3 | no conversion needed for MySql | sakai_10_2-10_3_oracle_conversion.sql |
|
| 10.4 | no conversion needed for MySql | no conversion needed for Oracle |
|
| 10.5 | sakai_10_1-10_5_mysql_conversion.sql | sakai_10_3-10_5_oracle_conversion.sql |
|