Skip to content
Branch: master
Find file History
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
..
Failed to load latest commit information.
README-PERMISSION-BACKFILLS.txt
README.md
sakai_10_0-10_1_mysql_conversion.sql
sakai_10_0-10_1_oracle_conversion.sql
sakai_10_0_mysql_conversion.sql
sakai_10_0_oracle_conversion.sql
sakai_10_1-10_2_oracle_conversion.sql
sakai_10_1-10_5_mysql_conversion.sql
sakai_10_2-10_3_oracle_conversion.sql
sakai_10_3-10_5_oracle_conversion.sql
sakai_10_5-10_6_mysql_conversion.sql
sakai_10_5-10_6_oracle_conversion.sql
sakai_10_6-10_7_oracle_conversion.sql
sakai_10_7-10_8_mysql_conversion.sql
sakai_10_7-10_8_oracle_conversion.sql
sakai_11_0-11_1_mysql_conversion.sql
sakai_11_0-11_1_oracle_conversion.sql
sakai_11_1-11_2_mysql_conversion.sql
sakai_11_1-11_2_oracle_conversion.sql
sakai_11_2-11_3_mysql_conversion.sql
sakai_11_2-11_3_oracle_conversion.sql
sakai_11_3-11_4_mysql_conversion.sql
sakai_11_3-11_4_oracle_conversion.sql
sakai_11_4-11_5_mysql_conversion.sql
sakai_11_4-11_5_oracle_conversion.sql
sakai_11_mysql_conversion.sql
sakai_11_oracle_conversion.sql
sakai_12_mysql_conversion.sql
sakai_12_oracle_conversion.sql
sakai_19_mysql_conversion.sql
sakai_19_oracle_conversion.sql
sakai_1_5-2_0_conversion.sql
sakai_1_5-2_0_mysql_conversion.sql
sakai_20_mysql_conversion.sql
sakai_20_oracle_conversion.sql
sakai_2_0-2_1_mysql_conversion.sql
sakai_2_0-2_1_oracle_conversion.sql
sakai_2_1_0-2_1_1_mysql_conversion.sql
sakai_2_1_0-2_1_1_oracle_conversion.sql
sakai_2_1_1-2_1_2_mysql_conversion.sql
sakai_2_1_1-2_1_2_oracle_conversion.sql
sakai_2_1_2-2_2_0_mysql_conversion.sql
sakai_2_1_2-2_2_0_oracle_conversion.sql
sakai_2_2_0-2_2_1_mysql_conversion.sql
sakai_2_2_0-2_2_1_oracle_conversion.sql
sakai_2_2_1-2_3_1_mysql_conversion.sql
sakai_2_2_1-2_3_1_oracle_conversion.sql
sakai_2_3_0-2_3_1_mysql_conversion.sql
sakai_2_3_0-2_3_1_oracle_conversion.sql
sakai_2_3_1-2_4_0_mysql_conversion.sql
sakai_2_3_1-2_4_0_oracle_conversion.sql
sakai_2_4_0-2_5_0_mysql_conversion.sql
sakai_2_4_0-2_5_0_oracle_conversion.sql
sakai_2_5_0-2_5_2_mysql_conversion.sql
sakai_2_5_0-2_5_2_oracle_conversion.sql
sakai_2_5_2-2_5_3_mysql_conversion.sql
sakai_2_5_2-2_5_3_oracle_conversion.sql
sakai_2_5_3-2_5_4_mysql_conversion.sql
sakai_2_5_3-2_5_4_oracle_conversion.sql
sakai_2_5_5-2_5_6_mysql_conversion.sql
sakai_2_5_5-2_5_6_oracle_conversion.sql
sakai_2_6_0-2_6_1_mysql_conversion.sql
sakai_2_6_0-2_6_1_oracle_conversion.sql
sakai_2_6_0_mysql_conversion.sql
sakai_2_6_0_oracle_conversion.sql
sakai_2_6_2-2_6_3_mysql_conversion.sql
sakai_2_6_2-2_6_3_oracle_conversion.sql
sakai_2_7_0-2_7_1_mysql_conversion.sql
sakai_2_7_0-2_7_1_oracle_conversion.sql
sakai_2_7_0_mysql_conversion.sql
sakai_2_7_0_oracle_conversion.sql
sakai_2_7_1-2_7_2_mysql_conversion.sql
sakai_2_7_1-2_7_2_oracle_conversion.sql
sakai_2_7_2-2_7_3_mysql_conversion.sql
sakai_2_7_2-2_7_3_oracle_conversion.sql
sakai_2_8_0-2_8_1_mysql_conversion.sql
sakai_2_8_0-2_8_1_oracle_conversion.sql
sakai_2_8_0_mysql_conversion.sql
sakai_2_8_0_mysql_hbm_indexes.sql
sakai_2_8_0_oracle_conversion.sql
sakai_2_8_0_oracle_hbm_indexes.sql
sakai_2_8_1-2_8_2_mysql_conversion.sql
sakai_2_8_1-2_8_2_oracle_conversion.sql
sakai_2_8_2-2_8_3_mysql_conversion.sql
sakai_2_8_2-2_8_3_oracle_conversion.sql
sakai_2_9_0-2_9_1_mysql_conversion.sql
sakai_2_9_0-2_9_1_oracle_conversion.sql
sakai_2_9_0_mysql_conversion.sql
sakai_2_9_0_oracle_conversion.sql
sakai_2_9_1-2_9_2_mysql_conversion.sql
sakai_2_9_1-2_9_2_oracle_conversion.sql
sakai_2_9_2-2_9_3_mysql_conversion.sql
sakai_2_9_2-2_9_3_oracle_conversion.sql
sam-787-mysql.sql
sam-787-oracle.sql

README.md

For the most up-to-date conversion scripts please see the files in https://github.com/sakaiproject/sakai/tree/master/reference/docs/conversion

You should be able to check just this directory out with subversion using the command:

svn co https://github.com/sakaiproject/sakai/trunk/reference/docs/conversion

Or just clone it from Github.

You need to run all scripts in order to ensure a proper conversion. For instance if upgrading to 11 from 10.3, you need to see if scripts exist for 10.4, 10.5, 10.6, etc before running the 11.0 script.

A database conversion is typically required in order to upgrade from one Sakai version to another. Database conversion scripts -- in distinct versions for MySQL and Oracle, respectively -- are found in the reference/docs/conversion folder in the master branch.

In the same directory you will also find conversion scripts for earlier Sakai releases. Migration from an earlier version will require the successive application of all intermediate scripts (see the following table). You cannot, for example, move from 2.6.1 to 2.9.0 by applying a single script. You will need to run 6 or 7 scripts all in a row. (warning) Note for oracle, some of the scripts will leave your indexes in an invalid state because of LONG->CLOB conversion. You will need to run this script to find the invalid/unusable indexes, THEN run the result of this script to alter these indexes. select 'alter index '||index_name||' rebuild online;' from user_indexes where status = 'INVALID' or status = 'UNUSABLE';

-- Run the resulting SQL commands this script generates if any) (warning) As a general rule, be sure to read through the conversion scripts before applying them. The conversion scripts are generic in the sense that they do not take into account any special customizations you may have made - such as new roles, or the deployment of additional tools or if you are migrating from 2.4.x - and they may complicate your migration with unintended consequences if you execute them blindly. (minus) For conversions prior to 2.6 please see the 2.8 install guide. Conversions from much older are not very well supported or tested but should still work.

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 for an important property setting issue (not a database conversion issue).

You can’t perform that action at this time.