MIS Systems Thread, Moving SIMS Server to new machine in Technical; Hi Guys
As part of a proposed network redesign at a school I look after, we want to move the ...
22nd October 2010, 10:46 PM #1
- Rep Power
Moving SIMS Server to new machine
As part of a proposed network redesign at a school I look after, we want to move the SIMS installation do a dedicated server. At present, everything at the school runs from one single server and we want to get SIMS moved off for reasons of security and availability.
I've spoken to capita who have quoted £550 to do the work for us, but Im wondering what would be involved in doing this myself?
The company i work for does outsourced IT for businesses and schools so I am no amateur at SQL Server and Windows Server 2003 etc.
Has anyone undertaken anything like this themselves and if so how straightforward was it?
One last thing, the current server runs Server 2003 64bit and SQL 2008 64 bit aswell. The new server will more than likely be running the 32 bit server and 32 bit SQL, will this make the process any more difficult?
IDG Tech News
23rd October 2010, 07:22 AM #2
Hi Josh, the process wont be particularly difficult, but if you don't have the experience with SIMS, Capita may not support your installation afterwards. I think £550 isn't bad, i thought they normally charged closer to a grand with a whole day on site.
Lots of us have done this before and there are many other threads on this topic, so there's no point regurgitating it all again. You can try the move and test it out at your own risk, before making it live.
The general process is install svr, install sql, run simsinst to put sims files in place, detach your current db, copy to new location and attach there, reattach the old one back so it still works as a backup, setup connect.ini to point to the correct location, copy the document storage over to the new server into correctly named folders, open sims and tell it where docstorage is. I think that's it really, unless i've forgotten something really simple.
23rd October 2010, 09:45 AM #3
No that is just about it vik!
Have no idea what effect moving back from 64bit to 32bit will have on the db, if anything. Might question what the move back, if you already have that in place why not stay with that architecture (everything is going that was anyway!)?
23rd October 2010, 11:39 AM #4
- Rep Power
Thanks for your responses guys.
Greed, the reason for moving back is that the schools have had some compatibility issues with 64bit server and also, they machine only has a couple of gig of RAM anyway which kind of makes using 64bit a little bit pointless. I will see how it goes in that respect i think.
Vikpaw, i thought it would be fairly straightforward. I do have a fair amount of experience with SIMS from the installation of the client on teachers machines etc so I have a pretty good idea of how it works. I think i may build a virtual 2003 server in our Lab here and do a test setup and migration of SIMS onto that as a test.
Thanks for the advice!
23rd October 2010, 02:19 PM #5
Definitely do a virtual test, and in fact why not keep the real live server virtual. We just did it here over the summer and it's much more robust for say updates, when you want to quickly undo using a snapshot. I must have used that feature at least 3 or 4 times at the end of the summer, and again in late august for the summer update.
The instructions must be right if GREED agreeds(!) with me as it was his instructions i followed the very first time i set up a test server, all those many years ago.
Things to look out for are that you don't run both at once, and the doc server is setup correctly. sometimes you have to go to the local folder and run the dmconfig utility manually to force it to redirect. Otherwise you'll end up with it looking for the old server and if it's still on, it will send files there.
23rd October 2010, 02:58 PM #6
- Rep Power
Vik, im actually considering virtualising both servers (plus an additional linux server running fog. I have quite an extensive background in virtualization and have labs running both ESXi and Xenserver and think that re-virtualization the existing single server is quite a good fit for this school.
23rd October 2010, 04:10 PM #7
Vik I completely forgot that, yes that is the process I used many a time!
In fact I still have them somewhere! lol
Josh that is a good reason!
Last edited by GREED; 23rd October 2010 at 04:14 PM.
23rd October 2010, 05:45 PM #8
I don't think moving between 32bit and 64bit should have any major affect on the DB. I occaisonally take the latest backup and restore it to a Windows XP virtual machine for testing/training use and have never had any problems crop up that I can think of.
24th October 2010, 05:29 PM #9
- Rep Power
Thats good to know cache! I will give it a try during the week and let u know how it goes.
By ful56_uk in forum MIS Systems
Last Post: 11th October 2010, 11:41 AM
By mattstevenson2005 in forum MIS Systems
Last Post: 16th July 2009, 03:05 PM
By beeswax in forum EduGeek Joomla 1.5 Package
Last Post: 7th April 2009, 12:18 PM
By matt40k in forum MIS Systems
Last Post: 22nd August 2008, 08:58 PM
By jasonb007 in forum MIS Systems
Last Post: 16th May 2007, 11:38 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)