Migration - Database Conversion Scripts (2.x)

A database conversion is typically required between Sakai versions. Database conversion scripts - in distinct versions for MySQL and Oracle, respectively - are found in the reference/docs/conversion folder of the release or in our SVN repository:

In the same directory you'll also find conversion scripts for earlier Sakai versions. 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.2.1 to 2.4.0 by applying a single script. The were no database schema changes between 2.4.0 and 2.4.1, so you can migrate to the 2.5.0 schema from either version using the 2.4.0 scripts.

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.

Upgrade Step	Conversion script prefix	MySQL	Oracle
1.5 to 2.0	sakai_1_5-2_0	sakai_1_5-2_0_mysql_conversion.sql	sakai_1_5-2_0_conversion.sql
2.0 to 2.1	sakai_2_0-2_1	sakai_2_0-2_1_mysql_conversion.sql	sakai_2_0-2_1_oracle_conversion.sql
2.1 to 2.1.1	sakai_2_1-2_1_1	sakai_2_1_0-2_1_1_mysql_conversion.sql	sakai_2_1_0-2_1_1_oracle_conversion.sql
2.1.1 to 2.1.2	sakai_2_1_1-2_1_2	sakai_2_1_1-2_1_2_mysql_conversion.sql	sakai_2_1_1-2_1_2_oracle_conversion.sql
2.1.2 to 2.2.0	sakai_2_1_2-2_2_0	sakai_2_1_2-2_2_0_mysql_conversion.sql	sakai_2_1_2-2_2_0_oracle_conversion.sql
2.2.0 to 2.2.1	sakai_2_2_0-2_2_1	sakai_2_2_0-2_2_1_mysql_conversion.sql	sakai_2_2_0-2_2_1_oracle_conversion.sql
2.2.1 to 2.3.2	sakai_2_2_1-2_3_1	sakai_2_2_1-2_3_1_mysql_conversion.sql	sakai_2_2_1-2_3_1_oracle_conversion.sql
2.3.0 to 2.3.2	sakai_2_3_0-2_3_1	sakai_2_3_0-2_3_1_mysql_conversion.sql	sakai_2_3_0-2_3_1_oracle_conversion.sql
2.3.1 to 2.3.2	no schema changes
2.3.2 to 2.4.1	sakai_2_3_1-2_4_0	sakai_2_3_1-2_4_0_mysql_conversion.sql	sakai_2_3_1-2_4_0_oracle_conversion.sql
2.4.0 to 2.4.1	no schema changes
2.4.1 to 2.5.0	sakai_2_4_0-2_5_0	sakai_2_4_0-2_5_0_mysql_conversion.sql	sakai_2_4_0-2_5_0_oracle_conversion.sql
2.5.0 to 2.5.1	sakai_2_5_0-2_5_1	sakai_2_5_0-2_5_1_mysql_conversion.sql	sakai_2_5_0-2_5_1_oracle_conversion.sql
2.5.0 to 2.5.2	sakai_2_5_0-2_5_2	sakai_2_5_0-2_5_2_mysql_conversion.sql	sakai_2_5_0-2_5_2_oracle_conversion.sql
2.5.1 to 2.5.2	no schema changes
2.5.2 to 2.5.3	sakai_2_5_2-2_5_3	sakai_2_5_2-2_5_3_mysql_conversion.sql	sakai_2_5_2-2_5_3_oracle_conversion.sql
2.5.3 to 2.5.4	sakai_2_5_3-2_5_4	sakai_2_5_3-2_5_4_mysql_conversion.sql	sakai_2_5_3-2_5_4_oracle_conversion.sql
2.5.4 to 2.5.5	no schema changes
2.5.5 to 2.5.6	sakai_2_5_5-2_5_6	sakai_2_5_5-2_5_6_mysql_conversion.sql	sakai_2_5_5-2_5_6_oracle_conversion.sql
2.6.0	sakai_2_6_0	sakai_2_6_0_mysql_conversion.sql	sakai_2_6_0_oracle_conversion.sql
2.6.0 to 2.6.1	sakai_2_6_0-2_6_1	sakai_2_6_0-2_6_1_mysql_conversion.sql	sakai_2_6_0-2_6_1_oracle_conversion.sql
2.6.1 to 2.6.2	sakai_2_6_1-2_6_2	sakai_2_6_1-2_6_2_mysql_conversion.sql	sakai_2_6_1-2_6_2_oracle_conversion.sql

The latter version represents a security release that replaced one or more intervening Sakai releases. In this case the provided conversion script contains the necessary information to migrate you through the no longer available, intervening Sakai versions.

There were no schema changes between Sakai 2.5.1 and 2.5.2. The Sakai 2.5.1 and 2.5.2 releases are both based on 2.5.0; Sakai 2.5.1 containing a major portfolio tool bug that was reverted in Sakai 2.5.2.

No 2.6.* conversion scripts yet exist for DB2. Please contact John Bush if the absence of scripts poses a problem for you.

Migration - Database Conversion Scripts (2.x)

Labels