+ Post New Thread
Results 1 to 6 of 6
MIS Systems Thread, sql 2008 in Technical; As I understand it we need to upgrade Sims to SQL 2008 this year As of 1st May SQL 2008 ...
  1. #1

    Join Date
    Apr 2008
    Location
    Notts
    Posts
    54
    Thank Post
    1
    Thanked 2 Times in 2 Posts
    Rep Power
    13

    sql 2008

    As I understand it we need to upgrade Sims to SQL 2008 this year

    As of 1st May SQL 2008 R2 becomes available together with a 15% price increase

    Is there any advantage in having R2 for Sims?

    Thanks

  2. #2

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,326
    Thank Post
    36
    Thanked 353 Times in 238 Posts
    Rep Power
    79
    We haven't tested on R2 yet so it isn't supported. You can buy R2 and downgrade under MS's licencing.

  3. #3


    Join Date
    Sep 2007
    Location
    UK
    Posts
    5,426
    Thank Post
    1,437
    Thanked 880 Times in 565 Posts
    Rep Power
    645
    I've just run off the info. sheet for upgrading from 2005 to 2008. It says that the express version is free but no longer suitable for High Schools and Middle Schools with a large number of SIMS users and workstations. We currently have 3 workstations using SIMS all of the time and 4 intermittent but the plan is to put SIMS into every classroom, so that will be an additional 20 odd users but again intermittent.

    Should we be considering purchasing the SQL 2008 standard version or will we be ok with express?

  4. #4

    SYNACK's Avatar
    Join Date
    Oct 2007
    Posts
    11,172
    Thank Post
    868
    Thanked 2,699 Times in 2,288 Posts
    Blog Entries
    11
    Rep Power
    772
    @laserblazer - Express will run it (unless your DB is bigger than 4GB) but may slow down under the additional user load as it is limited to 1GB of cache memory and one CPU core. The upgrade from 2008 express to standard can be done in place and is realitivly easy so I would suggest starting out with express and only purchasing and upgrading if nessisary.

    Upgrade SQL Express to Standard or Enterprise - Todd Klindt's SharePoint Admin Blog
    http://msdn.microsoft.com/en-us/library/ms143393.aspx

    @THERADIOTELETUBBY - I would try to get the latest version then use downgrade rights as has been suggested, from what I have heard on this forum about SIMS eventually they will require the R2 version and that extra 15% now may save you the cost of a full upgrade in future.
    Last edited by SYNACK; 12th May 2010 at 07:26 AM.

  5. Thanks to SYNACK from:

    laserblazer (12th May 2010)

  6. #5
    robins's Avatar
    Join Date
    May 2007
    Posts
    44
    Thank Post
    15
    Thanked 5 Times in 5 Posts
    Rep Power
    15
    Has anyone tried SIMS on SQL 2008 std R2 32 bit with a single named instance. I hear its pretty stable generally - after all it's not a major release. I'm still on Win2003 as when I switched to SIMS Win2008 hadn't been OK'ed by Capita which was annoying.

  7. #6

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,408
    Thank Post
    368
    Thanked 639 Times in 521 Posts
    Rep Power
    158
    I've had a number of bugs with SQL 2008 R2, remember, you can't restore back to SQL 2008 R1 either. It's not like Windows.

    I would SQL 2008 Express for now, it's really easy to upgrade to standard.

  8. Thanks to matt40k from:

    robins (1st June 2010)

SHARE:
+ Post New Thread

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. 2008 SQL migration
    By creese in forum MIS Systems
    Replies: 0
    Last Post: 22nd April 2010, 10:14 AM
  3. SQL 2008 express
    By Boon72 in forum Windows Server 2008 R2
    Replies: 1
    Last Post: 3rd February 2010, 10:55 AM
  4. SIMS SQL 2008 migration
    By matt40k in forum MIS Systems
    Replies: 0
    Last Post: 8th August 2009, 12:08 AM
  5. CMIS and SQL 2008 install
    By sgavan in forum MIS Systems
    Replies: 2
    Last Post: 9th July 2009, 02:31 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
  •