+ Post New Thread
Results 1 to 15 of 15
MIS Systems Thread, The SQL 2008 to 2012 upgrade in Technical; It seems it time to move database engines again, I'll be going from SQL2008 express to 2012 express.. or. anyone ...
  1. #1

    Join Date
    Jan 2008
    Location
    South West
    Posts
    1,842
    Thank Post
    219
    Thanked 271 Times in 219 Posts
    Rep Power
    70

    The SQL 2008 to 2012 upgrade

    It seems it time to move database engines again, I'll be going from SQL2008 express to 2012 express.. or.

    anyone know how much a full SQL instance costs through an EES agreement? is it worth it?

    740 pupils at the school.

    does it affect login times to sims or just reports?

  2. #2
    Boredguy's Avatar
    Join Date
    Jun 2011
    Location
    Swindon
    Posts
    729
    Thank Post
    5
    Thanked 159 Times in 148 Posts
    Rep Power
    56
    SQL is licensed either per core count (with the minimum being 4) or by Server & CALS.

    I just got a quote last week for our own SQL upgrade for SIMS, and the 2 Core license for SQL Standard was around £210 on EES, so that's a minimum of £420 on this licensing model.

    SQL Express is limited in the system resources it can use I believe, but SQL Express 2012 has increased the maximum database size upto 10Gb, so you may notice a speed increase.

  3. #3

    3s-gtech's Avatar
    Join Date
    Mar 2009
    Location
    Wales
    Posts
    3,104
    Thank Post
    161
    Thanked 655 Times in 588 Posts
    Rep Power
    169
    Exactly the same cost here, £420. Worked out slightly cheaper this year by core, where Server+CALs was cheaper before.

  4. #4

    Join Date
    Jan 2008
    Location
    South West
    Posts
    1,842
    Thank Post
    219
    Thanked 271 Times in 219 Posts
    Rep Power
    70
    erk... over 5 years that's another £2100 spent on SIMS. I think we'll put up with the slowness.

    EDIT: I'm actually annoyed the documentation now recommends that we run full SQL. (before it hasn't) of course we can use the express but any performance issues and they can shrug their shoulders. Hiding the fact that SIMS has just become more expensive
    Last edited by chazzy2501; 20th May 2014 at 12:21 PM. Reason: Annoyed

  5. #5

    3s-gtech's Avatar
    Join Date
    Mar 2009
    Location
    Wales
    Posts
    3,104
    Thank Post
    161
    Thanked 655 Times in 588 Posts
    Rep Power
    169
    Depends - how many cores has your SIMS server got? Get some quotes in - you will have far fewer FTE staff than us in which case the pricing may be significantly less for server+CAL. At least you'll have the documents necessary to decide.

  6. #6
    Boredguy's Avatar
    Join Date
    Jun 2011
    Location
    Swindon
    Posts
    729
    Thank Post
    5
    Thanked 159 Times in 148 Posts
    Rep Power
    56
    SIMS can be expensive to keep running to their recommendations, but it does depend on how much your using it. We have always been advised to use the full version even since it went to SQL, so it's something we have to factor in.
    When we moved to 2008 R2, we purchased perpetual licenses for the 2 processors as it worked out cheaper.
    Now we're going to tag our £900 bill onto our yearly EES renewal and that covers us as well for when SQL 2014 is supported (which should be next year if we're lucky)

  7. #7

    Join Date
    Feb 2007
    Location
    East Sussex
    Posts
    477
    Thank Post
    16
    Thanked 90 Times in 82 Posts
    Rep Power
    31
    We're planning to skip 2012. There is a 6 month overlap in support for 2008 r2 and 2014. We purchased 2008 r2 outright, and will probably look at doing the same for 2014.

    Steve

  8. #8

    Join Date
    Jan 2008
    Location
    South West
    Posts
    1,842
    Thank Post
    219
    Thanked 271 Times in 219 Posts
    Rep Power
    70
    my EES renewal is in 45 days, is it advisable to use a trail version of full 2012 until I get a license?

  9. #9
    woody's Avatar
    Join Date
    Jun 2005
    Location
    Carlisle, Cumbria
    Posts
    624
    Thank Post
    3
    Thanked 21 Times in 17 Posts
    Rep Power
    24
    As far as I was aware, you can install the full version and add it to your next EES order? A bit like if you get extra FTEs, you don't add them until renewal.

  10. #10
    Boredguy's Avatar
    Join Date
    Jun 2011
    Location
    Swindon
    Posts
    729
    Thank Post
    5
    Thanked 159 Times in 148 Posts
    Rep Power
    56
    Think you can add it to your renewal at any point. I'm just trying to keep my headaches down by waiting till that point since I know the prices won't alter drastically in the next 2 months.

    Check with your MS license supplier.

  11. #11
    Boredguy's Avatar
    Join Date
    Jun 2011
    Location
    Swindon
    Posts
    729
    Thank Post
    5
    Thanked 159 Times in 148 Posts
    Rep Power
    56
    Quote Originally Posted by woody View Post
    As far as I was aware, you can install the full version and add it to your next EES order? A bit like if you get extra FTEs, you don't add them until renewal.
    Not sure this is quite correct. Yes you can add additional instances of Office or Windows upgrade during the year, but SQL server is a separate component and surely needs to be licensed when you want to use it... Otherwise I'm installing SQL 2014 now

  12. #12

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,523
    Thank Post
    375
    Thanked 677 Times in 551 Posts
    Rep Power
    166
    Quote Originally Posted by chazzy2501 View Post
    is it advisable to use a trail version of full 2012 until I get a license?
    Install express, then upgrade the edition to standard when you've got the license, it's a 5 min job.

  13. Thanks to matt40k from:

    chazzy2501 (21st May 2014)

  14. #13

    Join Date
    Jan 2008
    Location
    South West
    Posts
    1,842
    Thank Post
    219
    Thanked 271 Times in 219 Posts
    Rep Power
    70
    Quote Originally Posted by matt40k View Post
    Install express, then upgrade the edition to standard when you've got the license, it's a 5 min job.
    That is great news! Woohoo...

    is it enter a key and reboot?

  15. #14

    fiza's Avatar
    Join Date
    Dec 2008
    Location
    London
    Posts
    2,372
    Thank Post
    477
    Thanked 339 Times in 287 Posts
    Rep Power
    158
    When is the cut-off to upgrade? I would guess before the Sims Summer upgrade?

  16. #15

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,523
    Thank Post
    375
    Thanked 677 Times in 551 Posts
    Rep Power
    166
    Quote Originally Posted by chazzy2501 View Post
    That is great news! Woohoo...

    is it enter a key and reboot?
    Kinda, run the installer on the iso\disc, left hand menu pick upgrade edition, usual next, next, next kinda thing. Key is pre-filled in the disc\iso image too. Don't think it needs a reboot either.



SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 9
    Last Post: 12th March 2014, 08:41 PM
  2. VMWare & SQL Server 2008 to 2012
    By tech-man in forum Thin Client and Virtual Machines
    Replies: 0
    Last Post: 3rd December 2013, 09:42 AM
  3. Replies: 13
    Last Post: 17th September 2013, 02:41 AM
  4. 2008 to 2012 inplace upgrade
    By Steve21 in forum Windows Server 2012
    Replies: 5
    Last Post: 15th July 2013, 04:08 PM
  5. Replies: 2
    Last Post: 22nd April 2010, 11:39 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
  •