+ Post New Thread
Results 1 to 13 of 13
MIS Systems Thread, Ease of SIMS migration to SQL 2005 in Technical; I need to get this sorted before Christmas. The current situation is: * Windows Server 2000 * SQL Server 2000 ...
  1. #1

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    Boston, MA
    Posts
    7,597
    Thank Post
    109
    Thanked 770 Times in 598 Posts
    Rep Power
    183

    Ease of SIMS migration to SQL 2005

    I need to get this sorted before Christmas. The current situation is:
    * Windows Server 2000
    * SQL Server 2000
    * SIMS with August Release applied

    I need to get it to:
    * Windows Server 2003
    * SQL Server 2005
    * SIMS migrated and fully patched

    My question is for those who have done this... is it worth paying £140 to have this done for me (bearing in mind that I would have to schedule downtime during working hours)? From reading the Capita instructions, the SIMS bit seems quite straight forward and an in-place upgrade of Server should be OK too.

  2. #2

    Join Date
    Nov 2006
    Location
    Kendal
    Posts
    1,555
    Thank Post
    112
    Thanked 177 Times in 144 Posts
    Rep Power
    72

    Re: Ease of SIMS migration to SQL 2005

    I did ours SQL 2000 to SQL 2005 + SIMS transfer & upgrade. It all went very smoothly with only 1 minor issue with the connect.ini

    Whole process took about 4 hours and I did it remotely from home so I could do it out of hours.

    I guess the only benefit of using Capita's managed service is if it does go wrong (and I have read lots of cases where it has) then it becomes Capita's problem to sort. If you do the upgrade and it goes wrong Capita will charge to sort out any data corruption issues.

  3. #3

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    Boston, MA
    Posts
    7,597
    Thank Post
    109
    Thanked 770 Times in 598 Posts
    Rep Power
    183

    Re: Ease of SIMS migration to SQL 2005

    Something else... would now be a good time to move to new hardware too?

    The existing box is a dual 2.4GHz Xeon with 1GB or RAM (stop laughing!) but it will probably do the job for a little longer... all be it slowly/

  4. #4

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    Boston, MA
    Posts
    7,597
    Thank Post
    109
    Thanked 770 Times in 598 Posts
    Rep Power
    183

    Re: Ease of SIMS migration to SQL 2005

    @jcollings: Our SIMS support is through the County support team... I was told that they would charge the £140 to do it from scratch if it went wrong. They also told me that I would receive NO telephone support for the upgrade because they are advising schools that they pay to have the upgrade done for them (something that I think is out of order but that's a different story).

  5. #5

    Join Date
    Mar 2006
    Location
    Yorkshire
    Posts
    5
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: Ease of SIMS migration to SQL 2005

    I did ours SQL 2000 to SQL 2005 + SIMS transfer & upgrade during October half term. Mine too went very smoothly apart from connect.ini problem and it only took me a morning to do. I wouldn't have paid our LEA to do it.

    There is also a lot of help now on the Capita website.

  6. #6

    Join Date
    Nov 2006
    Location
    Kendal
    Posts
    1,555
    Thank Post
    112
    Thanked 177 Times in 144 Posts
    Rep Power
    72

    Re: Ease of SIMS migration to SQL 2005

    @ric - I think their whole attitude to this has been poor if I'm honest. I have heard of more issues moving server than just doing the upgrade. A colleague yesterday was saying how they have moved the DB to another server and it just wouldn't reattach.

    As someone once said "Do ya feel lucky? Well do ya punk?"

    Russian roulette SIMS style.

  7. #7
    ChrisH's Avatar
    Join Date
    Jun 2005
    Location
    East Lancs
    Posts
    4,995
    Thank Post
    123
    Thanked 286 Times in 263 Posts
    Rep Power
    108

    Re: Ease of SIMS migration to SQL 2005

    Westfield did ours yesterday and it went fine. I would rather pay £140 and let them do it since they have done plenty of others and know the procedure.

  8. #8

    bossman's Avatar
    Join Date
    Nov 2005
    Location
    England
    Posts
    4,010
    Thank Post
    1,249
    Thanked 1,099 Times in 781 Posts
    Rep Power
    337

    Re: Ease of SIMS migration to SQL 2005

    Updated Sims to latest version, migrated and converted database from SQL2000 after backing up the server via tape, directories and Acronis (universal restore). Wiped the server (win2000) and installed fresh Windows 2003R2, set up partitions, installed SQL 2005 enterprise and reattached the database renaming as required then reinstalling a fresh sims.net with new doc server. Then reset all permisions on the server share and imported any documents into their retrospective directories. Approx 5 hours all told.

    Runs a little slower than it used to but only by a couple of secs looking at using the enterprise tools to speed things up.

  9. #9

    Domino's Avatar
    Join Date
    Oct 2006
    Location
    Bromley
    Posts
    4,109
    Thank Post
    217
    Thanked 1,343 Times in 821 Posts
    Blog Entries
    4
    Rep Power
    526

    Re: Ease of SIMS migration to SQL 2005

    The migration is fine, as is the install.

    We moved servers at the same time (i would advise it), and that was the hardest part. but I've previously posted links to very detailed instructions on how to do that.

    All in all, if you've a half term to do it in, and you've a full server backup- do it yourself

  10. #10


    Join Date
    Sep 2007
    Location
    UK
    Posts
    5,463
    Thank Post
    1,462
    Thanked 892 Times in 573 Posts
    Rep Power
    647
    I've just started. Got to the bit where it says locate and run SIMSSQL2005.exe and the file doesn't exist! I'm sure everything up to there was done as per. but I took over from someone else.

  11. #11
    enjay's Avatar
    Join Date
    Apr 2007
    Location
    Reading, Berkshire, UK
    Posts
    4,496
    Thank Post
    282
    Thanked 196 Times in 167 Posts
    Rep Power
    76
    Quote Originally Posted by laserblazer View Post
    I've just started. Got to the bit where it says locate and run SIMSSQL2005.exe and the file doesn't exist! I'm sure everything up to there was done as per. but I took over from someone else.
    It should be in S:\SIMS\setups, but not until after you've run SQL2005Installation.exe (or some similarly-named file). If you don't have the latter, then run SOLUS, ticking the "CCS Installation Upgrade" box.

    The undocumented problem I hit was that you can't do this from a mapped drive - for convenience, I have S: on our server mapped to the SIMS folder on the same server, and it crashed the install when I did that. For some reason, you have to run the upgrades from their true location.

  12. #12


    Join Date
    Sep 2007
    Location
    UK
    Posts
    5,463
    Thank Post
    1,462
    Thanked 892 Times in 573 Posts
    Rep Power
    647
    Thanks, running Solus was the answer. No mention of that on the installation instructions

  13. #13
    enjay's Avatar
    Join Date
    Apr 2007
    Location
    Reading, Berkshire, UK
    Posts
    4,496
    Thank Post
    282
    Thanked 196 Times in 167 Posts
    Rep Power
    76
    Quote Originally Posted by laserblazer View Post
    Thanks, running Solus was the answer. No mention of that on the installation instructions
    Good, isn't it?! I had to phone Capita support to get told both those little nuggets. Their documentation truly is rubbish.



SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 1
    Last Post: 21st December 2007, 04:21 PM
  2. SIMs backup script after SQL 2005 migration failing...
    By mullet_man in forum MIS Systems
    Replies: 13
    Last Post: 23rd November 2007, 07:03 PM
  3. SIMS Migration help
    By randle in forum MIS Systems
    Replies: 17
    Last Post: 10th November 2007, 01:00 PM
  4. SIMS migration - help needed!
    By ndavies in forum MIS Systems
    Replies: 15
    Last Post: 9th October 2007, 03:21 PM
  5. SIMS - Migration to new Domain
    By Gatt in forum Windows
    Replies: 2
    Last Post: 20th December 2006, 02:06 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •