+ Post New Thread
Results 1 to 14 of 14
MIS Systems Thread, Upgrading SIMS to SQL 2005 in Technical; SIMS currently runs on SQL 2000. We are required to upgrade to SQL 2005 as part of the next SIMS ...
  1. #1

    Join Date
    Sep 2007
    Posts
    181
    Thank Post
    4
    Thanked 2 Times in 2 Posts
    Rep Power
    15

    Upgrading SIMS to SQL 2005

    SIMS currently runs on SQL 2000.

    We are required to upgrade to SQL 2005 as part of the next SIMS release.

    What is the best and/or easiest way to do this?
    Last edited by AnnDroyd; 11th May 2008 at 10:05 PM.

  2. #2

    Join Date
    Mar 2007
    Location
    Heywood, Lancs
    Posts
    226
    Thank Post
    7
    Thanked 54 Times in 49 Posts
    Rep Power
    29

    Re: Upgrading SIMS to SQL 2005

    Would suggest you get SIMS updated to Sept (or August) release first and iron out any snags with that, if not already done so.

    If you are intending to use full fat SQL 2005 you can install this in parallel with 2000 on the same server without affecting the working system. Once this is running OK, then use the Capita tools to migrate the database over to 2005.
    We have done the first part but not the second.......

    Beware that the install requires a few restarts and it needs to be patched up to SP2: took us about 2 hours in total one evening last week.

    We use full fat SQL, so not sure about whether SQL express will install in tandem with the desktop engine if you are using these.

  3. #3

    Gatt's Avatar
    Join Date
    Jan 2006
    Posts
    6,820
    Thank Post
    883
    Thanked 685 Times in 454 Posts
    Rep Power
    505

    Re: Upgrading SIMS to SQL 2005

    Still waiting on our LEA to migrate SIMS over to 2005...

  4. #4

    Join Date
    Sep 2007
    Posts
    181
    Thank Post
    4
    Thanked 2 Times in 2 Posts
    Rep Power
    15

    Re: Upgrading SIMS to SQL 2005

    I understood that we needed to be on SQL 2005 before we could upgrade to the September/August version. That was why I wanted to do it!

  5. #5

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    18,529
    Thank Post
    527
    Thanked 2,648 Times in 2,049 Posts
    Blog Entries
    24
    Rep Power
    925

    Re: Upgrading SIMS to SQL 2005

    It is required for the November release...

  6. #6
    DreddMetal's Avatar
    Join Date
    May 2007
    Posts
    91
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    16

    Re: Upgrading SIMS to SQL 2005

    Capita now say that if your a secondary you need to be on SQL2005 before the november upgrade or if your a primary before the december upgrade.

    No idea why they changed their mind but thats where they stand on the matter at the moment i believe.

  7. #7

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    18,529
    Thank Post
    527
    Thanked 2,648 Times in 2,049 Posts
    Blog Entries
    24
    Rep Power
    925

    Re: Upgrading SIMS to SQL 2005

    What about us middle schools?

  8. #8
    DMcCoy's Avatar
    Join Date
    Oct 2005
    Location
    Isle of Wight
    Posts
    3,505
    Thank Post
    10
    Thanked 508 Times in 445 Posts
    Rep Power
    116

    Re: Upgrading SIMS to SQL 2005

    SQL 2005 conversion can be done *after* the August update not before. There is a very good guide on supportnet (My file is called SIMSSQL2005Migration_12873.pdf not sure what KB its under).

  9. #9

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,404
    Thank Post
    38
    Thanked 387 Times in 262 Posts
    Rep Power
    85

    Re: Upgrading SIMS to SQL 2005

    LA support teams said they could not migrate all their schools to SQL 2005 in the time frame so we extended primary support until the end of Jan 2008. Primary schools can do the January census on either 2000 or 2005. Middle schools demeed secondary need to move to 2005 before the January census.

  10. #10
    DreddMetal's Avatar
    Join Date
    May 2007
    Posts
    91
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    16

    Re: Upgrading SIMS to SQL 2005

    Thanks for the reply Phil, does that mean that primary school can install the November and December upgrade whilst still on MSDE?

  11. #11

    Join Date
    Sep 2007
    Posts
    181
    Thank Post
    4
    Thanked 2 Times in 2 Posts
    Rep Power
    15

    Re: Upgrading SIMS to SQL 2005

    I've just installed SQL 2005 in preparation for the November update.

    I have a copy of the sims.mdf and sims.ldf files which I can attach to the new database, but how do you restore the contents of the master database?

    Come to think of it, how did the master database get created in the first place? For schools using MSDE, I believe they install a Capita customised version which has this in place, but if you start with a blank SQL installation, how does this data get created?

    Without it, you get a database connection error when trying to log in (user simsinit not recognised, or similar).

  12. #12
    DreddMetal's Avatar
    Join Date
    May 2007
    Posts
    91
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    16

    Re: Upgrading SIMS to SQL 2005

    Just tell let everyone else know the answer to my question:

    For Primary and Special schools we will support Nov and Dec on MSDE/SQL2000 but not for Secondary Schools.



    There is a separate installer for FMS which needs to be requested from distribution.


    Regards


    Simon



    Simon Smith

    Head of SIMS Product Management
    CAPITA Children's Services

  13. #13

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,404
    Thank Post
    38
    Thanked 387 Times in 262 Posts
    Rep Power
    85

    Re: Upgrading SIMS to SQL 2005

    Sorry my PC has been out of commission!

    DreddMetal, you can't install MSDE now as MS has withdrawn our right to distribute it. (Replacing it with SQL Express) You can however upgrade the primary school to November on MSDE.

  14. #14
    DreddMetal's Avatar
    Join Date
    May 2007
    Posts
    91
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    16

    Re: Upgrading SIMS to SQL 2005

    Thanks for the reply Phil



SHARE:
+ Post New Thread

Similar Threads

  1. Problems installing SQL 2005 for SIMS
    By timbo343 in forum Windows
    Replies: 6
    Last Post: 7th November 2007, 11:27 AM
  2. SIMS on MSSQL 2005
    By AlexB in forum MIS Systems
    Replies: 9
    Last Post: 7th November 2007, 10:20 AM
  3. SQL 2005 and SIMS FMS Finance
    By thom in forum MIS Systems
    Replies: 2
    Last Post: 30th August 2007, 05:50 PM
  4. SIMS SQL 2005
    By steve in forum MIS Systems
    Replies: 54
    Last Post: 20th August 2007, 02:35 PM
  5. SIMS + SQL 2005?
    By Norphy in forum MIS Systems
    Replies: 22
    Last Post: 5th April 2007, 11:20 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
  •