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 & 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 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 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. -- Christopher Dawkins, Felsted School, Dunmow, Essex CM6 3JG 01371-822698/821076 or 07798 636725 cchd@felsted.essex.sch.uk