+ Post New Thread
Results 1 to 9 of 9
MIS Systems Thread, Which version of SQL? in Technical; Is the Standard full edition of SQL going to provide everything needed for SIMS?...
  1. #1

    Edu-IT's Avatar
    Join Date
    Nov 2007
    Posts
    7,122
    Thank Post
    403
    Thanked 619 Times in 566 Posts
    Rep Power
    180

    Which version of SQL?

    Is the Standard full edition of SQL going to provide everything needed for SIMS?

  2. #2

    Michael's Avatar
    Join Date
    Dec 2005
    Location
    Birmingham
    Posts
    9,262
    Thank Post
    242
    Thanked 1,568 Times in 1,250 Posts
    Rep Power
    340
    I believe SQL 2008 Standard is fairly common for running SIMS these days. SQL 2008 Express should be avoided due to the memory limitations. SQL 2008 Standard is only limited by the memory available to the OS itself, be it 4GB, 8GB, 16GB etc...

  3. #3

    jinnantonnixx's Avatar
    Join Date
    Mar 2011
    Location
    In the Calamatorium.
    Posts
    1,958
    Thank Post
    109
    Thanked 482 Times in 331 Posts
    Blog Entries
    2
    Rep Power
    281
    Download comparison chart from here
    http://www.microsoft.com/en-us/downl....aspx?id=23365

    Features Supported by the Editions of SQL Server 2008

    Most of the differences won't affect the average installation. SIMS will run fine on a standard version. You'll need the advanced version if your site needs certain features that are only available on the advanced version, such as DB snapshots and witness-less mirroring.
    Last edited by jinnantonnixx; 25th April 2013 at 02:51 PM.

  4. #4

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    But if you're changing go for 2012, assuming you don't need discover or other things, or at least keep them on a separate 2008 instance so SIMS is partially future proofed.

  5. #5

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,663
    Thank Post
    516
    Thanked 2,446 Times in 1,894 Posts
    Blog Entries
    24
    Rep Power
    831
    @Rawns has had trouble getting SIMS to play nice being split across 2 databases - ie. SIMS in 2012 and Discover/SOLUS3 in 2008 R2. We were going to go down this route when we moved recently, but decided against it due to the KISS principle... Stick with 2008 R2 until 2012 is fully supported.

    Also, people should stop using '2008' and use 2008 R2 - they are 2 different products.

    Standard edition is all you need also, unless you're a primary school then Express will work fine - we used it up until this last migration.

  6. Thanks to localzuk from:

    vikpaw (27th April 2013)

  7. #6
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 489 Times in 375 Posts
    Rep Power
    0
    Correct. Been doing a lot of in house testing trying to get sims and discover working with sims on 2012 and discover on 2008 R2. Spent ages trying to get the transfer to work but it just refused to work. I've still not heard of anyone who has got this working either!

  8. Thanks to Rawns from:

    vikpaw (27th April 2013)

  9. #7

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Capita in their test setup of course!

  10. #8
    Jobos's Avatar
    Join Date
    Apr 2007
    Posts
    1,134
    Thank Post
    178
    Thanked 49 Times in 42 Posts
    Rep Power
    24
    Digging up an old thread but I'm setting up a new virtual sims server over the holidays and not sure which version of sql 2012 to go with. It's for a primary school 3 admin and 10 teacher machines. Discover not used yet but expect it's use more over the coming year. Teachers doing registers only.

    Thanks in advance

  11. #9

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,663
    Thank Post
    516
    Thanked 2,446 Times in 1,894 Posts
    Blog Entries
    24
    Rep Power
    831
    I'd say Express is ideal for that size school. We only switched to full a a couple of months ago, and we're triple that size.

  12. Thanks to localzuk from:

    Jobos (9th July 2013)

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] What versions of SQL is SIMS supported on?
    By FN-GM in forum MIS Systems
    Replies: 12
    Last Post: 8th January 2013, 12:58 PM
  2. Which version of 2008?
    By TechSupp in forum Windows Server 2008 R2
    Replies: 5
    Last Post: 4th February 2011, 01:17 PM
  3. Pre-release version of SQL!
    By CadlaM in forum Windows Server 2008 R2
    Replies: 2
    Last Post: 25th November 2010, 01:55 PM
  4. Which version of 7?
    By garethedmondson in forum Windows 7
    Replies: 5
    Last Post: 23rd February 2010, 11:38 AM
  5. Which version of wise package studio?
    By nicholab in forum Educational Software
    Replies: 2
    Last Post: 28th November 2007, 09:07 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
  •