Mailinglist Archive: opensuse-edu (179 mails)

< Previous Next >
Re: [suse-linux-uk-schools] CCM Facility
  • From: "Mark Evans" <mpe@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
  • Date: Mon, 21 Jan 2002 09:35:29 +0000 (UTC)
  • Message-id: <20020121093547.26370.qmail@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
> > We are looking to deploy CCM's Facility timetable / scheduler next September
> > which uses M$ SQL 7 as standard. Does any one out there use this software
> > with a Linux DB, DB2 and Oracle are the most obvious. My manager is not keen
> > on MYSQL, but if some one is using it for this successfully it might change
> > his mind!
> We had some arguments with them last year. They said it would run on any
> database back end, it's only a front end. So we asked about PostgreSQL &

Quite a few people (in all sorts of situations) just don't appear
to understand the meaning of the world "any"...

> MySQL. Eventually they said it would run on Oracle, Access or MS SQL.
> It's not worth their while, they said, to convert it for any other SQL
> engine cos no-one uses them. So we bought a machine with MS SQL 2000 on

Chicken/Egg... Anyway isn't one of the meanings of SQL "Standard
Query Language" :)

> it, and the database, and then it turned out that no-one had yet tried MS
> SQL 2000. So we got new instructions for that, then it turned out we'd

This kind of thing dosn't sound exactly unfamiliar.

> need Access as well for the transfer process, so we bought and installed
> Office Pro. But the real killer was that where they had said they'd
> "transfer our data" for us, that meant that if we converted our data
> ourselves into a fixed format Excel spreadsheet, then they'd convert that
> spreadsheet into a database. Needless to say, there were a lot of issues
> in trying to squeeze our data (free format addreses, for example) into the
> format of their spreadsheet. But we've done it, we have a CCM database
> running. No further comment, yet, we've had it five months and have not
> yet got it working.

Mark Evans
St. Peter's CofE High School
Phone: +44 1392 204764 X109
Fax: +44 1392 204763

< Previous Next >
Follow Ups