[Building Sakai] 2x: Micorsoft Sql Server conversion scripts: plan to move from trunk to contrib (and remove from 2.8.x, 2.7.x)

[Matthew Jones]

I don't think support for mssql was ever fully implemented or run anywhere.
I believe that rsmart is still supporting the DB2 functionality.

Oracle and Mysql are the only 2 that we run database comparisons against and
someone takes extra time to verify the conversions work. They are also the
only 2 with active QA servers running on them. Marist used to have some DB2
QA servers but both of them appear to be down. I run the only Windows QA
server but it connects up to a mysql database backend.

If any database besides those 3 were ever supported, it seems like it would
be nice to have an open source database like postgresql available, or
investigate how well (if) it runs on one of the open mysql forks like
MariaDB.

On Tue, Mar 8, 2011 at 8:33 AM, Jean-Francois Leveque <
jean-francois.leveque at upmc.fr> wrote:

> Removal seems the best choice. Is there a point of keeping mssql scripts
> in 2.6?
>
> Might be worth removing other mssql files elsewhere in the source.
>
> There may be other unsupported DB files elsewhere.
>
> What's the current status of DB2 and other DBs not supported by the
> community?
>
> Cheers,
>
> J-F
>
> Steve Swinsburg a écrit :
> > Is there any point in keeping them at all, even in contrib? They are so
> out of date and totally unsupported that moving them to contrib might give
> false hope.
> >
> > According to a 2006 JIRA: https://jira.sakaiproject.org/browse/SAK-7002,
> Microsoft allegedly stated that they would be prepared to fund ongoing
> support - I'm not sure if that eventuated. Plus also it means that
> developers need access to a non-free proprietary database and a Windows
> environment, and considering our developer base, that would be too much of a
> resource requirement.
> >
> > regards,
> > Steve
> >
> >
> > On 08/03/2011, at 5:12 AM, Anthony Whyte wrote:
> >
> >> Barring objections I plan to move the 2.7 and 2.8 Microsoft SQL server
> conversion scripts from trunk to contrib as well as remove them from the
> 2.7.x and 2.8.x maintenance branches.  The reasons are as follows:
> >>
> >> 1.  The Sakai Community does not publicly support MS SQL server for the
> Sakai CLE.
> >> 2.  Due to no. 1 Sakai CLE developers are under no obligation to
> maintain the MS SQL server conversion scripts and few choose to do so.
> >> 3.  Also due to no. 1 the MS SQL conversions scripts are not tested by
> QA.
> >> 4.  As a result of nos. 1-3 the existing MS SQL conversion scripts for
> both 2.7 and 2.8 are in an anemic condition when compared to the
> community-supported MySQL and Oracle conversion scripts (see comparison
> below).
> >> 5.  Due to no. 4 anyone attempting to perform an upgrade of a MS SQL
> database when upgrading their Sakai CLE to 2.7 or 2.8 is doomed to failure.
> >>
> >> Leaving the MS SQL conversion scripts in place gives the impression that
> we support MS SQL server when currently we do not.  Given their existing
> state--incomplete, unsupported and not QA'd--they should be pushed to
> contrib (over even simply deleted) in order to eliminate any misconception
> that may arise from their presence in our production releases and
> maintenance branches.
> >>
> >> If you object to their removal, be prepared to state how you intend to
> both maintain and test the MS SQL conversion scripts for upcoming releases,
> including 2.8.0.
> >>
> >> Cheers,
> >>
> >> Anthony
> >>
> >>
> >> Trunk:
> >>
> >> 2.7.0:
> https://source.sakaiproject.org/svn/reference/trunk/docs/conversion/sakai_2_7_0_mssql_conversion.sql
> >> 2.8.0:
> https://source.sakaiproject.org/svn/reference/trunk/docs/conversion/sakai_2_8_0_mssql_conversion.sql
> >>
> >> Compare these to
> >>
> >> 2.7.0:
> https://source.sakaiproject.org/svn/reference/trunk/docs/conversion/sakai_2_7_0_mysql_conversion.sql
> >> 2.7.0:
> https://source.sakaiproject.org/svn/reference/trunk/docs/conversion/sakai_2_7_0_oracle_conversion.sql
> >>
> >> 2.8.0:
> https://source.sakaiproject.org/svn/reference/trunk/docs/conversion/sakai_2_8_0_mysql_conversion.sql
> >> 2.8.0:
> https://source.sakaiproject.org/svn/reference/trunk/docs/conversion/sakai_2_8_0_oracle_conversion.sql
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to
> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20110308/f00095d1/attachment.html