[WG: Sakai QA] 2.7.0 conversion scripts: Samigo

[Anthony Whyte]

I expect to pull MS SQL conversion script from 2.7.x per my earlier email recommendation of today.  If you want to update the MSSQL conversion scripts in trunk, feel free.

Cheers,

Anth


Begin forwarded message:

> From: Anthony Whyte <arwhyte at umich.edu>
> Date: April 22, 2010 10:00:22 AM EDT
> To: Developers Sakai-Dev <sakai-dev at collab.sakaiproject.org>
> Cc: Sakai QA <sakai-qa at collab.sakaiproject.org>
> Subject: [Building Sakai] Conversion scripts: Microsoft SQL Server scripts (who maintains?)
> 
> MS SQL conversion scripts were added to trunk in July 2009 (SAK-16610) and a copy resides in 2.7.x.  The script is in a rather anemic state when compared to the Oracle and MySQL conversion scripts.  Over the intervening months a few intrepid developers have added a script here and there but I assume that the current incompleteness of the 2.7.0/2.8.0 MS SQL conversion scripts is due to the fact that most developers are unfamiliar with SQL Server and hesitant to update its scripts and are also working under the assumption that it's not their responsibility to maintain these scripts.
> 
> Is anyone overseeing the MS SQL scripts and if so do they plan to keep them up-to-date?  I do not recall that we plan to offer MS SQL Server support in Sakai 2.7 or a future 2.x release.  If no plan exists, I plan to remove the MS SQL script from the 2.7.x branch since it provides a false impression of community support.  Whether or not the scripts should be removed from trunk and relocated to contrib is I think an issue worth discussing.
> 
> Cheers,
> 
> Anthony
> 
> 
> MS SQL Server-related Jiras
> 
> http://jira.sakaiproject.org/browse/SAK-16610  (MS SQL conversion scripts added)
> http://jira.sakaiproject.org/browse/SAK-8706 (db refactoring by G. Golden and J. Bush)
> http://jira.sakaiproject.org/browse/SAK-7002 (add MS SQL support -- open)



On Apr 22, 2010, at 3:04 PM, Karen Tsao wrote:

> 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/40dfd5a6/attachment.html