+ Post New Thread
Results 1 to 13 of 13
Windows Thread, SQL Upgrade in Technical; Hi All Newbie to this site so apologise if this has already been mentioned. I would like to attempt the ...
  1. #1

    Join Date
    Dec 2009
    Location
    UK
    Posts
    113
    Thank Post
    15
    Thanked 1 Time in 1 Post
    Rep Power
    0

    SQL Upgrade

    Hi All
    Newbie to this site so apologise if this has already been mentioned. I would like to attempt the SIMS SQL Migration from 2005 to 2008. I know Capita deadline is Oct 2010 but I have a few new servers to install early Jan. A company has quoted 300 to do this but I know my way round a server etc and was wondering whether anyone had a tutorial or guide on exactly how to do this.

    Any help would be appreciated

    Thanks

  2. #2

    teejay's Avatar
    Join Date
    Apr 2008
    Posts
    3,161
    Thank Post
    284
    Thanked 768 Times in 579 Posts
    Rep Power
    334
    All the info is on Capita Supportnet, pm me if you can't find it and I'll email it to you.

  3. Thanks to teejay from:

    boogster (15th December 2009)

  4. #3
    zag
    zag is offline
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    3,762
    Thank Post
    897
    Thanked 416 Times in 350 Posts
    Blog Entries
    12
    Rep Power
    86
    Capita supply the instructions, its not difficult to do.

  5. #4

    Join Date
    Dec 2009
    Posts
    7
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    I am about to do the same, Crapita are charging 250 before Christmas or 450 in April! What a rip off!

  6. #5

    synaesthesia's Avatar
    Join Date
    Jan 2009
    Location
    Northamptonshire
    Posts
    5,866
    Thank Post
    574
    Thanked 998 Times in 770 Posts
    Blog Entries
    15
    Rep Power
    461
    250 here if ordered before end of this year and 350 thereafter. Not sure I'd expect much less, costwise.

  7. #6

    Join Date
    Dec 2009
    Posts
    7
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Yeah for sure, but how long will it take realistically!? It's not relative to other charges

  8. #7

    synaesthesia's Avatar
    Join Date
    Jan 2009
    Location
    Northamptonshire
    Posts
    5,866
    Thank Post
    574
    Thanked 998 Times in 770 Posts
    Blog Entries
    15
    Rep Power
    461
    Half day job, or so I'm told. How long it actually takes, I've no idea. Imagine that depends on the size of the databases too.
    On which note the above prices may well just be primaries.

  9. #8
    Cache's Avatar
    Join Date
    Apr 2008
    Location
    Cumbria
    Posts
    1,198
    Thank Post
    447
    Thanked 173 Times in 170 Posts
    Blog Entries
    3
    Rep Power
    63
    The bursar was quite willing to pay for Capita to come in and do ours so I just filled out the order form.

    Since Capita had a problem getting dbattach to work properly after they migrated SIMS to a new server over the summer I'll let them go ahead and do it and save me having to spend hours trying to get it to work properly.

    Also gives me the comeback of everything on the server is your doing at the moment so you fix it which since it's my first time dealing with supporting SIMS I'm quite happy to have at the moment.

  10. #9

    Join Date
    Dec 2009
    Posts
    7
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    I'd much rather do it myself and charge the school myself! I only deal with primaries at the moment, so the db is quite small. Also in my experience Crapita engineers and staff aren't as clued up as they claim

  11. #10

    Join Date
    Dec 2009
    Location
    UK
    Posts
    113
    Thank Post
    15
    Thanked 1 Time in 1 Post
    Rep Power
    0

    SQL Migration

    GardnerIT

    That was exactly my way of thinking. I too only support Primary Schools with pretty small DB's. As long as I make sure I back up the DB's as standard then I am thinking...if it fails then at least the data will be in tact.

    TeeJay

    Many thanks for sending over docs etc...will come in really handy.


    I was having a read up and it mentioned that Capita Disk includes SQLExpress and migration tool....Do they send this out to schools or do the school have to request one?

  12. #11

    Join Date
    May 2008
    Posts
    518
    Thank Post
    18
    Thanked 8 Times in 8 Posts
    Rep Power
    15
    Ive just had a phone call from capita today saying about this which i never knew about. Does this mean they are forcing us to upgrade? and if we dont are they not going to support us?

  13. #12

    Edu-IT's Avatar
    Join Date
    Nov 2007
    Posts
    7,112
    Thank Post
    403
    Thanked 619 Times in 566 Posts
    Rep Power
    180
    Quote Originally Posted by techie08 View Post
    Ive just had a phone call from capita today saying about this which i never knew about. Does this mean they are forcing us to upgrade? and if we dont are they not going to support us?
    I think by the middle of next year they're wanting everyone to have upgraded, but don't quote me on this.

  14. #13

    Join Date
    Dec 2009
    Location
    UK
    Posts
    113
    Thank Post
    15
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Quote Originally Posted by techie08 View Post
    Ive just had a phone call from capita today saying about this which i never knew about. Does this mean they are forcing us to upgrade? and if we dont are they not going to support us?

    You have until Oct 2010 to have the SQL2008 upgrade. After this SIMS and all Solus upgrades will not work and I presume knowing Capita they will not support it.

SHARE:
+ Post New Thread

Similar Threads

  1. FMS Upgrade to SQL and CFR reports
    By wesleyw in forum MIS Systems
    Replies: 0
    Last Post: 3rd April 2008, 08:58 AM
  2. sims sql upgrade question
    By Uraken in forum MIS Systems
    Replies: 10
    Last Post: 18th March 2008, 03:18 PM
  3. Sims SQL 2005 upgrade on a new server?
    By zag in forum MIS Systems
    Replies: 11
    Last Post: 21st November 2007, 08:46 AM
  4. Replies: 12
    Last Post: 22nd October 2007, 07:15 PM
  5. CMIS SQL server upgrade.
    By dave-a in forum MIS Systems
    Replies: 3
    Last Post: 10th July 2007, 10:16 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
  •