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