MIS Systems Thread, Transfer to server in Technical; Hi everyone
Well i have worked in many schools and its the first time i have came across Serco Facility ...
21st May 2012, 01:03 PM #1
- Rep Power
Transfer to server
Well i have worked in many schools and its the first time i have came across Serco Facility MIS system. Now the situation is that the school have pulled out of the local council,so we have just brought some new computers to replace these ones. How the council setup serco was just to create a partition on the computer it self and run it from there then before the receptionist goes home she pops in a backup tape.
I wanna move all this data off this computer and put it on the server so it will be backup on a weekly basis.What would be the recommended way to do this?
map a drive with everything from that drive?
IDG Tech News
21st May 2012, 01:34 PM #2
There is most likely a SQL database on that machine somewhere which will need moving etc, If the school has no support from the LA perhaps a call to serco may be in order? Moving the database and re-installing the software (and assocated client files) is something that is very doable, but you will want to be able to back up the system and have support in the process.
21st May 2012, 02:50 PM #3
If CMIS has been installed on a workstation it is possible it may have been setup to work off an Access Database. Either way, if its Access or SQl, moving it onto a server should be straightforward. On the server, assuming you are going to use SQL, you will need an appropriate SQL plugin for your backup software i.e. Backup Exec. This will allow backups to run whilst the system is running which makes life easier. To automate CMIS backups you have to use a SQL backup procedure, the built in Facility software backup feature is manual only
21st May 2012, 03:03 PM #4
I'd call serco and talk to them, you'll be paying enough for support, best get your money's worth. If you explain the situation i'm sure they will be helpful.
21st May 2012, 03:14 PM #5
- Rep Power
I have called serco there have refused to help because im not part of the school on their system.
I think this may be more trouble then i expected haha
21st May 2012, 03:20 PM #6
In which case you need to get someone higher up the foodchain to call them and explain whats going on, because if you aren't supported you won't get updates and eventually the school will get into all kinds of grief with the DfE as the data exports won't give the info required as the updates change what gets exported. They will probably have to part with money.
21st May 2012, 03:27 PM #7
+1 for what @Oaktech said. You need to be supported in order to get the updates to be able to do Census reports etc. There should be somebody higher up with details registered with Serco (the head maybe?) who will have to have you added onto the system.
I can give you a fairly good set of instructions to do the data move but you need to get yourslef sorted with Serco first
21st May 2012, 04:05 PM #8
- Rep Power
Basically no one has details registered with serco, the local council took the agreement out with serco for there schools, there support. There installed for the school prt of the support cost.
Originally Posted by themightymrp
21st May 2012, 04:10 PM #9
then you need to speak to the LA or get the head to write a letter to serco explaining, to get your details registered so they will speak to you. I think, if you've come away from the LA you will need to get your DfE number re-registered with serco so you become your own entity with them. This WILL cost money!
Last edited by Oaktech; 21st May 2012 at 04:14 PM.
21st May 2012, 04:11 PM #10
hi ryan it looks like you might need to look at the bigger picture here.
you are running a MIS with NO external support and no Local authority support, correct?
21st May 2012, 04:13 PM #11
Originally Posted by andydis
21st May 2012, 04:57 PM #12
This sounds like a recipe for disaster long term. If the school have pulled out of support with the LA, they will need support from us and they'll need new releases etc otherwise they won't be able to completely legal requirements such as census returns. Given that there was one last week it's possible theyre behind already and don't even know it.
Please PM me your details so that I can put the right people at Serco in touch with the right people at the school, and the authority. Let's fix the roof before it rains rather than waiting for a downpour and everyone involved getting soaked.
Customer Success Manager
The above post is my own and does not represent the opinions of my employer or their associates.
3 Thanks to michael2k6:
john (21st May 2012), Oaktech (21st May 2012), vikpaw (27th May 2012)
23rd May 2012, 09:45 AM #13
- Rep Power
Just to let you know its working fine now. Cmis is only run off a excel database so no sql needed. Mapped a drive and then put the shortcuts on the users desktop.
Originally Posted by michael2k6
Its working great there now.
The school are moving over to RM mis system in the summer holidays,so this will do until then
23rd May 2012, 06:56 PM #14
It's either not Serco software or it's not running in Excel - just for anyone else out there, it might be running in access on a peer to peer system if in a primary school rather than putting SQL on one of the clients.
Sounds like you've found a solution in the interim, if you've got any issues post back. Bear in mind that if one of the other machines on the peer to peer still has an open connection to the database then any automated backup of the mdb file you have isn't going to do much.
If i were you i'd be looking to set a startup in the BIOS of that machine at a particular time followed by a scheduled batch file of xcopy to ship it over to the server, then another scheduled batch to shut said machine down.
Or move it to the server, point the dsn at that, and schedule a shutdown script on the client machines so that if there's anything left on overnight it's shutdown before the normal server backup takes place.
By robinhood in forum School ICT Policies
Last Post: 27th March 2007, 11:03 AM
By TSCNUK in forum Windows
Last Post: 21st November 2006, 11:34 AM
By OutToLunch in forum How do you do....it?
Last Post: 24th July 2006, 03:03 PM
By tosca925 in forum Windows
Last Post: 28th June 2006, 10:39 PM
By ChrisH in forum Hardware
Last Post: 8th December 2005, 11:53 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)