Christopher, I am in the early stages (6 months or so) of implementing a CMIS system.
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.
Whats not working? I have it running against an MS-SQL 6.5 backend and am having various problems with tempdb filling up. I had thought that when a given client terminates, any structures in tempdb associated with it would be dropped, but this seems not to be the case. Currently, with two clients accessing it, the server consumes its (enormous) tempdb space and I have to stop and re-start it after a mornings work. Have you anything similar? It may of course be some setting I've got wrong. There do seem to be some very bizarre design decisions that the designers have made. For example, at the end of an academic year, when pupils are rolled up, a fresh copy of every student is made. So, a given student may appear in 5 or more distinct records in the main pupil table, each with sex, ethnic group etc fields. How often to students change their ethnic group on transition from one year group to the next? Also, some details seem saved multiple times across many tables, rather than just being saved once in a single table. Having said this, the help-desk staff do seem eager to resolve issues that arise, although some are outstanding. regards Richard richard@tortoise.demon.co.uk