+ Post New Thread
Page 1 of 4 1234 LastLast
Results 1 to 15 of 55
MIS Systems Thread, SIMS SQL 2005 in Technical; A technical roadmap has been published on the CapitaES site. SQL2005 migration will be available in August 07. All updates ...
  1. #1
    steve's Avatar
    Join Date
    Oct 2005
    Location
    West Yorkshire
    Posts
    1,043
    Thank Post
    22
    Thanked 177 Times in 123 Posts
    Rep Power
    52

    SIMS SQL 2005

    A technical roadmap has been published on the CapitaES site.

    SQL2005 migration will be available in August 07.

    All updates from August 07 on will only run on SQL 2005 / Express
    SQL 2005 will need .net 2 framework
    Support for Win2000 Pro is being dropped Feb 2008
    And of course Office 2003 is now needed for SIMS

    Plus the version of Veritas I have doesn't backup SQL 2005 either.

    Lucks like I'll be busy in the summer again :-)

  2. #2

    Join Date
    Feb 2007
    Location
    oxfordshire county council
    Posts
    20
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: SIMS SQL 2005

    what fun ....... thats why most of our schools have gone for SIMS being centrally hosted. leaves them to do whatever they like locally within the schools and we provide the infrastructure to run SIMS on. Best of both worlds.

    Steve Edgar

  3. #3
    sahmeepee's Avatar
    Join Date
    Oct 2005
    Location
    Greater Manchester
    Posts
    795
    Thank Post
    20
    Thanked 70 Times in 42 Posts
    Rep Power
    34

    Re: SIMS SQL 2005

    Just to add to Steve's comments, the versions of SIMS prior to August *won't* run on SQL Server 2005 according to (newbie EduGeek!) Toby Belfield.

    This means you will need to wait until the August release comes out, upgrade your SQL server to 2005, upgrade SIMS to August 07.

    They've done us a favour in doing this for August so we can do it in the holidays, but if it does overrun and become very late August I doubt we'll be doing any SIMS updates for some time.

  4. #4
    Norphy's Avatar
    Join Date
    Jan 2006
    Location
    Harpenden
    Posts
    2,360
    Thank Post
    54
    Thanked 309 Times in 240 Posts
    Blog Entries
    6
    Rep Power
    119

    Re: SIMS SQL 2005

    This is a good thing all things considered. There are no performance limitations with SQLEE like there are with MSDE (aside from the 1 CPU restriction) and the maximum database size doubles in size to 4GB. I'm very pleased Capita are making this move.

  5. #5

    Join Date
    Dec 2006
    Location
    Shrewsbury
    Posts
    40
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: SIMS SQL 2005

    All,

    Just to let you know - I am completely committed to ensuring that the releases are delivered on time. Especially something as important as the August Main Release - given the impact that it will have on schools. The plans are to make it available before Wednesday 1st August - before 10 am.

    Thank you for your kind comments - I am hoping that planning our upgrade to SQL 2005 to meet our August Release will give schools a window to carry out the upgrade.

    That being said, however, I am also well aware that many schools have really embedded SIMS into their school - in such a way that they find it difficult to live without it. So - any "inconvenience" is big. I will do everything I can to minimise this inconvenience.

    As you will know, my responsibilities also extend to Examinations Organiser - and even though there are plans to enhance the product as part of the August Release, these enhancements are not necessary for the Results sessions mid-August. There are no plans to change any part of the Performance Tables this year.

    I will be mindful of the importance that there must be no disruption in the Examinations area in August.

    Regards,

    Toby Belfield
    Capita

  6. #6

    Join Date
    Nov 2006
    Location
    Lincolnshire
    Posts
    40
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: SIMS SQL 2005

    Hi Toby,

    Thanks for making your comments on here

    I also noted your post on Support Net, but the following statement is confusing (or perhaps it's just the way I'm reading it)

    "We anticipate schools upgrading to SQL Server 2005/Express from the beginning of August onwards - and once it is installed, immediately applying the most recent release (which could be August, September, November or even December".

    What you appear to be saying is that nobody should be installing SQL 05 until Aug, when the SIMS upgrade is ready. But then you say that it should be installed at the beginning of Aug before the SIMS upgrade (which could be Aug/Sep....etc).

    Are you saying that, in a nutshell, SQL 05 should not be installed until immediately before the SIMS upgrade, but the upgrade could be delayed ?

    Sorry if that sounds a bit thick, it just doesn't read right.

    Additionally, for my twopenneth worth, August is a seriously bad time to be making major upgrades like this, particularly if there is to be a delay. As well as the normal (and very busy) summer installations/upgrades etc, we have staff in over most of August doing timetables/curriculum planning etc. Surely this should have been projected to July to allow for "mishaps"?

  7. #7

    Join Date
    Feb 2006
    Posts
    1,187
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: SIMS SQL 2005

    I think Ausgust was chosen with the idea that you can afford to have down time during the holidays.

    I would have been nice to have a satellite version of Exams Organiser just in case

  8. #8

    Join Date
    Dec 2006
    Location
    Shrewsbury
    Posts
    40
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: SIMS SQL 2005

    I appreciate the concern about August - and several schools/Support Units have contacted me with concerns that schools are actually shut in August.

    However, in my view, there is never going to be a "good time" for this sort of thing.

    The SQL Server 2005 upgrade needs to be done immediately prior to a SIMS upgrade. This is why schools should not do it before August. However - after August (but before, say December - when January census dates loom), should be fine.

    A BETA version of Examinations Organiser will be possible - and thanks for suggesting this. I will remember to make this happen.

    Our Release schedule - which means that Main Releases are delivered on the first of February, May, August and November, means that July is not really an option.

    I hope this helps.

    Please do not hesitate to contact me directly (toby.belfield@capita.co.uk) - where I hope to be able to continue to answer queries. Regrettably - I do not always have time to monitor these forums - but will do the best that I can.

    Regards,

    Toby Belfield
    Capita

  9. #9

    Join Date
    Feb 2006
    Posts
    1,187
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: SIMS SQL 2005

    Hey! What's David Cameron doing on the EduGeek MIS forum

    Thanks for the email address but I hope you have a good spam filter

  10. #10

    Join Date
    Dec 2006
    Location
    Shrewsbury
    Posts
    40
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: SIMS SQL 2005

    I am trying to work out whether your reference to David Cameron is my picture - or my posting!

    As for the good spam filter - Capita is quite good at that sort of thing. However - I am currently receiving around 150-200 emails per day, so would appreciate only serious queries, so that I can concentrate on getting things done!

    Regards,

    Toby Belfield
    Capita

  11. #11

    Join Date
    Feb 2006
    Posts
    1,187
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: SIMS SQL 2005

    Quote Originally Posted by Toby.Belfield
    I am trying to work out whether your reference to David Cameron is my picture - or my posting!
    Just the picture. A true conservative would have stuck with SQL 2000

    [qoute]As for the good spam filter - Capita is quite good at that sort of thing.[/quote] I hope so as there lots of web crawlers out there.

    However - I am currently receiving around 150-200 emails per day, so would appreciate only serious queries, so that I can concentrate on getting things done!
    Sleep is for wimps

    Anyway nice of you and Phil to show your face on EduGeek.

  12. #12

    Join Date
    Feb 2007
    Location
    Bloxham, Oxfordshire
    Posts
    3
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: SIMS SQL 2005

    I am concerned with the scope of this update. If anything does go wrong then with the results season upon us anything that screws that up is going to make life a misery, guess who will get the blame. No doubt half the Capita staff will be on holiday at that time.

    Just for Capitas benefit we techies don't spend the whole of the summer hols sitting around waiting to accomodate SIMs upgrades, we already have planned a large range of updates, enhancements and changes for this time.

    Whilst I agree with Steve Edgar that schools in Oxfordshire on the central hosting won't have to worry about that side they will still have to update workstations and at a recent technicians those representing schools that are hosted centrally were knashing their teeth over various problems.

  13. #13

    Join Date
    Jan 2007
    Posts
    100
    Thank Post
    0
    Thanked 34 Times in 23 Posts
    Rep Power
    21

    Re: SIMS SQL 2005

    dlanor, oxfordshire schools do not have to do anything for the upgrades, they simply log onto a session on one of our servers, there is no local sims install so there are no ws's to upgrade.

  14. #14

    Join Date
    Feb 2006
    Posts
    1,187
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: SIMS SQL 2005

    @dlanor

    To be fair this change would have to be made sometime and is forced by Microsoft's insistence on dropping support for MS SQL Server 2000 imminetly.

    I think people should seriously consider having a standalone setup (with all the info needed for results) just in case.

  15. #15

    Join Date
    Feb 2007
    Location
    Bloxham, Oxfordshire
    Posts
    3
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: SIMS SQL 2005

    Just goes to show that senior moments get us all at times, Greg is right the workstation updates would be done on the terminal services computers.

    Don't get me wrong I am more than happy that SQL will be updated, about time too. What concerns me is the timing, it is simply adding another job when I have got a large program of work planned already (I would like a week off during the summer).

    Is a standalone setup practical as a backup, after all that is going to add yet more work apart from preparing another SQL server we would have to transfer a copy of the SIMs db at the last minute, and as we have several office staff working through the holidays using SIMS it starts to get complicated.

    Toby is right that there is no easy time for such a change I just hope that it does not slip like the Feb update as that will really complicate matters! :drinkers:

SHARE:
+ Post New Thread
Page 1 of 4 1234 LastLast

Similar Threads

  1. Problems installing SQL 2005 for SIMS
    By timbo343 in forum Windows
    Replies: 6
    Last Post: 7th November 2007, 10:27 AM
  2. SIMS on MSSQL 2005
    By AlexB in forum MIS Systems
    Replies: 9
    Last Post: 7th November 2007, 09:20 AM
  3. Upgrading SIMS to SQL 2005
    By AnnDroyd in forum MIS Systems
    Replies: 13
    Last Post: 9th October 2007, 03:02 PM
  4. SQL 2005 and SIMS FMS Finance
    By thom in forum MIS Systems
    Replies: 2
    Last Post: 30th August 2007, 04:50 PM
  5. SIMS + SQL 2005?
    By Norphy in forum MIS Systems
    Replies: 22
    Last Post: 5th April 2007, 10:20 AM

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
  •