+ Post New Thread
Results 1 to 7 of 7
MIS Systems Thread, Which SQL version? in Technical; I've stuck this in here as we need to upgrade our version of SQL(which runs PASS) from 2000. But my ...
  1. #1

    Join Date
    Mar 2007
    Location
    Devon
    Posts
    1,042
    Thank Post
    226
    Thanked 63 Times in 56 Posts
    Rep Power
    30

    Which SQL version?

    I've stuck this in here as we need to upgrade our version of SQL(which runs PASS) from 2000. But my question is do i hold on a couple of months and go for 2008 or stick with the tried and tested 2005.

    When are MS planning on not supporting 2005? I'm guessing not for a fair few years so would be 1 plus.

  2. #2

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,439
    Thank Post
    368
    Thanked 650 Times in 531 Posts
    Rep Power
    160
    You not running SIMS .net?

    I would got 2005. Not much supports 2008... yet.
    I know MS is pushing Windows 2000 (server \ pro) to be replaced with vista\2008.

    Never used PASS, I think lol.

    I would got 2008 if you want a change and your current setup could late a bit longer, I would guess a few months of patches and such, I've had a similar thing with Bromcom

  3. #3

    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
    I would stick with SQL 2005 SP2 as it has been tried and tested. SQL 2008 has literally been out for days, so support will be very thin on the ground.

  4. #4

    Join Date
    Mar 2007
    Location
    Devon
    Posts
    1,042
    Thank Post
    226
    Thanked 63 Times in 56 Posts
    Rep Power
    30
    Thanks that was my thinking as well that 2005 will be well supported.

    Nope lucky enough to not use sims, use PASS which does everything sims does but seems a lot more stable lol

  5. #5

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,439
    Thank Post
    368
    Thanked 650 Times in 531 Posts
    Rep Power
    160
    LIES! TOTAL LIES!!

    SIMS .NET is the best, there is nothing else out there that does MIS stuff for schools, anyone that tells it does is a witch that should be burnt at the stake!!

    Lol....

    Capita keeps me in a job, at least till either;

    - They replace LEA support
    - They write supreme code that has non errors, is remotely controlled and dead easy to install etc etc etc

  6. #6

    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
    I doubt Sims.NET would actually work on SQL 2008 at the moment. Support for SQL 2005 was added later on. I suspect in the next year or so, support for SQL 2008 will be included too.

  7. #7

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,439
    Thank Post
    368
    Thanked 650 Times in 531 Posts
    Rep Power
    160
    I believe SQL 2005/2008 has a backward compatible with older databases, so you SHOULD be fine.

    Personally I would like the challange, PASS looks like a company who would like the challange, shame they can't use MySQL

    Yes, live data = stable. So whatever PASS recommend. I guess SQL2005.

SHARE:
+ Post New Thread

Similar Threads

  1. New version soon
    By mattx in forum EduGeek Admin Bar
    Replies: 4
    Last Post: 13th May 2008, 02:09 PM
  2. CMIS - New Version
    By stitch in forum MIS Systems
    Replies: 0
    Last Post: 30th April 2008, 03:25 PM
  3. SIMS Version - SQL extract
    By suzy_reid in forum MIS Systems
    Replies: 2
    Last Post: 24th January 2008, 04:55 PM
  4. MS SQL 2005 - Dump SQL
    By tom_newton in forum Windows
    Replies: 7
    Last Post: 23rd January 2008, 05:10 PM
  5. SIMS and SQL, which version
    By andrewsmart in forum MIS Systems
    Replies: 4
    Last Post: 14th June 2007, 08:13 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
  •