[WG: Sakai QA] 2.7.0 conversion scripts: Samigo

[Adam Hocek]

Hi Karen, 

The scripts were already in the sakai_2_7_0_oracle_conversoin.sql and have 
been been converted.  They will be included with the DB2 conversion 
scripts.

Thanks,
- Adam

Adam Hocek
Information Technology
Marist College
tel: 845-575-3948



From:
Karen Tsao <ktsao at stanford.edu>
To:
Anthony Whyte <arwhyte at umich.edu>
Cc:
Lydia Li <lydial at stanford.edu>, Sakai QA 
<sakai-qa at collab.sakaiproject.org>, Adam Hocek <adam.hocek at marist.edu>
Date:
04/22/2010 03:04 PM
Subject:
Re: 2.7.0 conversion scripts: Samigo
Sent by:
ktsao at hungs.org



Hi Adam,

There are four of Samigo's scripts missing in 
sakai_2_7_0_db2_conversion.sql. Here are the Oracle version:

alter table SAM_ITEM_T add PARTIAL_CREDIT_FLAG number(1,0) NULL;
alter table SAM_PUBLISHEDITEM_T add PARTIAL_CREDIT_FLAG number(1,0) NULL;
alter table SAM_ANSWER_T add PARTIAL_CREDIT float NULL;
alter table SAM_PUBLISHEDANSWER_T add PARTIAL_CREDIT float NULL; 

Can you please add them in? Thanks.

Anthony,

The MySql and Oracle scripts are good. Is there someone can help with 
MSSQL? Or we need to take care of it ourselves?

Thanks,
Karen

On Thu, Apr 22, 2010 at 11:32 AM, Anthony Whyte <arwhyte at umich.edu> wrote:
Karen--please review the 2.7.0 *.sql conversion scripts files for 
completeness with respect to Samigo.  Please add any scripts that are 
missing and note their addition on the QA list.

https://source.sakaiproject.org/svn/reference/trunk/docs/conversion/  

Adam Hocek of Marist is lead for the Db2 scripts.  Please cc him regarding 
any scripts that have yet to be added or are missing from the Db2 scripts.

If you can complete your review and, if necessary, update the conversion 
scripts by Friday, 7 May 2010 I would appreciate it.  This will allow us 
to cut a sakai-2.7.0 QA tag (hopefully rc01) on that date that includes 
up-to-date conversion scripts.

Cheers,

Anthony


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-qa/attachments/20100422/aaa260bf/attachment.html