+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 20
MIS Systems Thread, Moving from SQL Server 2005 to 2008 in Technical; ...
  1. #1
    speckytecky's Avatar
    Join Date
    May 2006
    Location
    UK
    Posts
    2,530
    Thank Post
    3,411
    Thanked 261 Times in 213 Posts
    Blog Entries
    3
    Rep Power
    110

    Moving from SQL Server 2005 to 2008

    My Admin staff tell me that over the Summer SIMS needs to be migrated from MS SQL Server 2005 to SQL 2008. when they migrated to SQL 2005 they had an expert in who charged £500 for the task and asked if this time it would be something I could do for my circa tenner an hour!

    I have never been much involved with SIMS before nor SQL Server - is there much involved and a muppets guide of what to do?

  2. #2

    Join Date
    Jun 2007
    Location
    Cumbria
    Posts
    148
    Thank Post
    11
    Thanked 12 Times in 11 Posts
    Rep Power
    18
    Eeek ! Where did your admin people hear this ?

    I had no idea...

  3. #3
    soapyfish's Avatar
    Join Date
    Dec 2008
    Location
    Hertfordshire
    Posts
    180
    Thank Post
    49
    Thanked 7 Times in 5 Posts
    Blog Entries
    1
    Rep Power
    13
    I believe that SIMs needs to be migrated to SQL 2008 before October 2010
    so this summer or next summer would be the ideal times to my mind.

    "Microsoft SQL Server 2008 and SQL Express
    From October 2009, Sims will be supported on SQL2008 and support for Sims on SQL2005 will be phased out by October 2010. During this time, all schools will need to complete a data migration process, using tools which will be provided by Capita.

    There is no direct upgrade route from SQL2005 to SQL2008, so this process will take place using a side by side installation approach. SITSS will provide further information regarding this process nearer the time as well as guidelines for schools who wish to undertake this process themselves. SITSS will also be offering to complete the SQL installation and migration process at a charge of approximately £300"
    Last edited by soapyfish; 8th July 2009 at 07:58 AM. Reason: extra text

  4. 2 Thanks to soapyfish:

    speckytecky (8th July 2009), westleya (8th July 2009)

  5. #4

    Join Date
    Mar 2006
    Location
    Chelmsford
    Posts
    115
    Thank Post
    0
    Thanked 4 Times in 4 Posts
    Rep Power
    19
    Here we go again!! More costs dumped on schools - we only moved to SQL2005 18 months ago and what a pain that was. At least we get a few years out of MS before being forced to spend more on upgrades. How long before we have to move to next generation 64 bit server? Why do we just lay down and accept this? We already pay massive amounts to use this MIS!

  6. Thanks to pmassingham from:

    speckytecky (9th July 2009)

  7. #5
    soapyfish's Avatar
    Join Date
    Dec 2008
    Location
    Hertfordshire
    Posts
    180
    Thank Post
    49
    Thanked 7 Times in 5 Posts
    Blog Entries
    1
    Rep Power
    13
    I am in the same boat it must have been 2 years ago at most that I moved to 2005,

    I don't know how long MS support a version of SQL but it must be more than a few years.

  8. #6

    Domino's Avatar
    Join Date
    Oct 2006
    Location
    Bromley
    Posts
    4,169
    Thank Post
    217
    Thanked 1,288 Times in 799 Posts
    Blog Entries
    4
    Rep Power
    512
    I remember the 2005 migration being pretty painless - took about 3 hours, with FMS being the pain.

    As long as you've planned it properly.

    Mind you it doesn't seem like they've allowed much time in between upgrades - Considering how long it took them to move from 2k to 2k5, maybe its because the difference isn't as huge this time round.

    Does anyone know if the CAL's are transferrable? or upgradeable?

  9. Thanks to Domino from:

    speckytecky (9th July 2009)

  10. #7
    soapyfish's Avatar
    Join Date
    Dec 2008
    Location
    Hertfordshire
    Posts
    180
    Thank Post
    49
    Thanked 7 Times in 5 Posts
    Blog Entries
    1
    Rep Power
    13
    I use the per processor licence not the CAL's

  11. #8

    Join Date
    Feb 2007
    Location
    Barnet
    Posts
    87
    Thank Post
    12
    Thanked 14 Times in 12 Posts
    Rep Power
    0

    SQL2008

    I think the admin staff who said 2008 is needed over the summer are planning for some pain. As SQL2008 is not supported until the October 2009 release and not compulsory until after October 2010 it seems a bit premature and there are likely to be osme aggravations to sort out so being an early adopter may not be best and being one before Oct 09 risks SIMs not working if it is done on a live system.

  12. Thanks to Jeremy69 from:

    speckytecky (9th July 2009)

  13. #9

    Join Date
    Nov 2005
    Location
    North
    Posts
    1,840
    Thank Post
    25
    Thanked 91 Times in 71 Posts
    Rep Power
    51
    Getting a shiny new server in october to all steam ahead for Server 2008 and SQL 2008

  14. #10
    soapyfish's Avatar
    Join Date
    Dec 2008
    Location
    Hertfordshire
    Posts
    180
    Thank Post
    49
    Thanked 7 Times in 5 Posts
    Blog Entries
    1
    Rep Power
    13
    What kind of spec are you looking at ? Its nearly time for me to replace my server too and the migration time seems to be the right time to do it get everything out of the way at once and limit the disruption to the users.

  15. #11

    Join Date
    May 2009
    Location
    Sheffield
    Posts
    249
    Thank Post
    23
    Thanked 37 Times in 28 Posts
    Rep Power
    20
    I'll check with our network admins if you want but I would expect you could just take a backup of the old database (using dbattach) and restore it into the new server, making sure you have the right user accounts and so-on created.

    It might be worth taking an image to have a virtualised version of the old server available just in case as well. Or build a new machine if the option's available.

  16. #12

    Michael's Avatar
    Join Date
    Dec 2005
    Location
    Birmingham
    Posts
    9,262
    Thank Post
    242
    Thanked 1,572 Times in 1,252 Posts
    Rep Power
    340
    To be honest I would wait until at least early 2010 before upgrading Sims.NET from SQL 2005 to SQL 2008. Something which could easily be done February half-term or even Easter 2010.

    SQL 2010 is scheduled for a mid 2010 release, so buying licenses for SQL 2008 next year will most likely cover you for SQL 2010 (including CALs).

  17. Thanks to Michael from:

    speckytecky (9th July 2009)

  18. #13

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,432
    Thank Post
    368
    Thanked 645 Times in 527 Posts
    Rep Power
    159
    Quote Originally Posted by pmassingham View Post
    Here we go again!! More costs dumped on schools - we only moved to SQL2005 18 months ago and what a pain that was. At least we get a few years out of MS before being forced to spend more on upgrades. How long before we have to move to next generation 64 bit server? Why do we just lay down and accept this? We already pay massive amounts to use this MIS!
    We do it so Capita support us, Capita do it so Microsoft supports them, Microsoft do it so they can support the new hardware. If you don't want to spend money on new software, don't spend money on new hardware!

  19. #14
    ArchersIT's Avatar
    Join Date
    Nov 2006
    Location
    Bedfordshire
    Posts
    114
    Thank Post
    14
    Thanked 24 Times in 20 Posts
    Rep Power
    20
    Quote Originally Posted by matt40k View Post
    We do it so Capita support us, Capita do it so Microsoft supports them, Microsoft do it so they can support the new hardware. If you don't want to spend money on new software, don't spend money on new hardware!
    While mainstream support for SQL 2005 will end in April 2011 (Please Verify your Location), Microsoft will continue to support it for security updates until April 2016.

    Presumably if this is going to be Capita's policy then they will be dropping support for Server 2003 before then as this will end mainstream support in July 2010 (Please Verify your Location).

    Jonathan

  20. #15

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,432
    Thank Post
    368
    Thanked 645 Times in 527 Posts
    Rep Power
    159
    @ArchersIT
    You seem to be forgetting that Capita are using Visual Studio and good support is only 5 years.

    I can't see why people moan, we're in the education sector, we get great discounts, guarantee money each year so we can have a rolling replacement cycle. If we can't keep up-to-date, who can!

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. Moodle / Server 2008 / IIS7 / MS SQL Server 2008 Express
    By Kamran7860 in forum Virtual Learning Platforms
    Replies: 3
    Last Post: 23rd November 2010, 06:03 AM
  2. SQL Server 2005 Not installing properly
    By Bugs in forum Windows
    Replies: 4
    Last Post: 20th May 2009, 01:29 PM
  3. SQL Server 2000/2005
    By techie08 in forum Windows Server 2000/2003
    Replies: 6
    Last Post: 12th February 2009, 11:06 PM
  4. SQL Server 2005 Backups Problem
    By ICTNUT in forum Windows
    Replies: 0
    Last Post: 7th July 2008, 09:53 AM
  5. sims.net sql server 2005
    By itgeek in forum MIS Systems
    Replies: 2
    Last Post: 14th March 2008, 06:02 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
  •