[Building Sakai] Upgrade from 2.5.4 to 2.7.x

[Nicola Monat-Jacobs]

Hi All -

I'm looking at upgrading a 2.5.4 dev server that we have to 2.7.x and I'm trying to put together a list of db update scripts that we'll need to run. This is a mysql instance. I'm trying to establish what these scripts do and if they're necessary for my scenario. Also, any thoughts on what it takes to upgrade to 2.7.x would be much appreciated too (the confluence page for this seems to be a work in progress and thus, I don't have permission to view it yet).

auto.ddl will be on, but it's been my experience that it often doesn't implement everything...

sakai_2_5_5-2_5_6_mysql_conversion.sql [1]
sakai_2_6_0_mysql_conversion.sql
sakai_2_6_0-2_6_1_mysql_conversion.sql
sakai_2_6_0-2_6_x_mysql_conversion005_SAK-14482.sql [2]
sakai_2_7_0_mysql_conversion.sql

From the 2.6 upgrade page [3], you'd also need to run this tool conversion, right?
MailArchive conversion (2.5 -> 2.6): There is a database script and mailarchive-runconversion.sh that needs to be run.

Might also need.....

MSGCNTR:
https://source.sakaiproject.org/svn/msgcntr/branches/msgcntr-2.7.x/messageforums-docs/SAK-11740_mysql.sql
https://source.sakaiproject.org/svn/msgcntr/branches/msgcntr-2.7.x/messageforums-docs/SAK_SAK-15052_mysql.sql

m2->m3 conversion script? Necessary? Not sure what this is for.
https://source.sakaiproject.org/svn/msgcntr/branches/msgcntr-2.7.x/messageforums-docs/updating/mfr_m2-m3_mysq_conversion.sql

SAMIGO update:
https://source.sakaiproject.org/svn/sam/branches/sakai_2-6-x/docs/auto_submit/auto_submit_mysql.sql 
https://source.sakaiproject.org/svn/sam/branches/samigo-2.7.x/docs/conversion/samigo_2_6_x-2_7_0_mysql_conversion.sql

MELETE
(Not sure what version of melete our dev server is on, need to check.)
./melete/components/src/sql/mysql/melete27.sql

./syllabus/syllabus-app/src/sql/mysql/SAK-14291-mysql.sql see http://jira.sakaiproject.org/browse/SAK-14291


Thanks!
Nicola


[1] This script is listed on http://confluence.sakaiproject.org/display/DOC/Upgrade+%282.6%29 with the others, but according to http://collab.sakaiproject.org/pipermail/production/2010-January/000488.html is probably not necessary.

[2] Small patch, can be skipped if necessary

[3] http://confluence.sakaiproject.org/display/DOC/Upgrade+%282.6%29