+ Post New Thread
Results 1 to 13 of 13
Windows Thread, SIMS forcing upgrade from SQL 2000 to 2005, Advice needed in Technical; Hi Having to upgrade the server from SQL 2000 to 2005 because SIMS says the Nov update will only work ...
  1. #1
    Grommit's Avatar
    Join Date
    Sep 2006
    Location
    Weston-super-Mare
    Posts
    1,335
    Thank Post
    31
    Thanked 54 Times in 31 Posts
    Rep Power
    25

    SIMS forcing upgrade from SQL 2000 to 2005, Advice needed

    Hi

    Having to upgrade the server from SQL 2000 to 2005 because SIMS says the Nov update will only work on 2005..

    any advice on how to do this..

    I have purchased a single CPU license and software for £650..

    so what's next ?.. I back up the LDF and MDF with Backup Exec

  2. #2
    steve's Avatar
    Join Date
    Oct 2005
    Location
    West Yorkshire
    Posts
    1,043
    Thank Post
    22
    Thanked 177 Times in 123 Posts
    Rep Power
    52

    Re: SIMS forcing upgrade from SQL 2000 to 2005, Advice neede

    Having spent the last week doing this, just a warning it doesn't always go to plan!

    Are you upgrading on the same server? If so it will make things much easier.

    Make sure you have plenty of free disk space.

    You need to have upgraded to the August release or later.

    This will then give you access to the migration utilities via SOLUS - if your support provider has enabled them.

    Something I've had a fair bit of trouble with is the new trusted logins - if a user exists in SIMS that you have removed from your AD, it will kick up a fuss. Make sure SIMS trusted logins have a corresponding AD account.

    So you've done the most important step, make a backup.
    Next step, make another :-)

    A copy of the capita migration guide is here

    Next stop is Support Net KB71936 - How do you install SQL 2005

    Once you have installed SQL 2005, you can move on to the next step.
    Don't skip creating an instance - otherwise you be given a crappy default one.

    Run the migration software - this will create extra files in your sims\setups folder.

    Then it should just be a case of following through the wizard - skipping the SQL express install.

    If anything fails it should roll back automatically.


    If you're migrating to another server, welcome to my personal hell for the last week. Just finished the upgrade today. Several virtual PC trials and test runs and a brand spanking new sims server all up and running :-)

  3. #3
    DMcCoy's Avatar
    Join Date
    Oct 2005
    Location
    Isle of Wight
    Posts
    3,456
    Thank Post
    10
    Thanked 494 Times in 434 Posts
    Rep Power
    112

    Re: SIMS forcing upgrade from SQL 2000 to 2005, Advice needed

    Remember to install a new instance of 2005 server, do NOT upgrade the 2000 one.

  4. #4

    tech_guy's Avatar
    Join Date
    May 2007
    Location
    That little bit in the middle of Little Old England
    Posts
    8,136
    Thank Post
    1,913
    Thanked 1,345 Times in 743 Posts
    Blog Entries
    3
    Rep Power
    395

    Re: SIMS forcing upgrade from SQL 2000 to 2005, Advice needed

    I'm doing my SQL 2005 install & Sims.Net migration on Monday. Aint looking forward to it.

    It doesn't help that our Sims support at the LEA don't provide support during the holidays........ :-(

  5. #5
    Grommit's Avatar
    Join Date
    Sep 2006
    Location
    Weston-super-Mare
    Posts
    1,335
    Thank Post
    31
    Thanked 54 Times in 31 Posts
    Rep Power
    25

    Re: SIMS forcing upgrade from SQL 2000 to 2005, Advice needed

    Many Thanks... doing the SIMS Server SQL upgrade on the existing SIMS Server (Server 2003 and SQL 2000) on Wednesday..

    How long do you expect it to take ?

  6. #6

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,684
    Thank Post
    516
    Thanked 2,453 Times in 1,899 Posts
    Blog Entries
    24
    Rep Power
    833

    Re: SIMS forcing upgrade from SQL 2000 to 2005, Advice needed

    Grommit, as you are in Somerset, don't you follow the centralised way of managing SIMS? Ie the somerset build? If you do, SCC have said they will be releasing information shortly on how to do it smoothly...

  7. #7
    Grommit's Avatar
    Join Date
    Sep 2006
    Location
    Weston-super-Mare
    Posts
    1,335
    Thank Post
    31
    Thanked 54 Times in 31 Posts
    Rep Power
    25

    Re: SIMS forcing upgrade from SQL 2000 to 2005, Advice needed

    Quote Originally Posted by localzuk
    Grommit, as you are in Somerset, don't you follow the centralised way of managing SIMS? Ie the somerset build? If you do, SCC have said they will be releasing information shortly on how to do it smoothly...
    I just live there..

    we are a stand alone Foundation School..

  8. #8

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,684
    Thank Post
    516
    Thanked 2,453 Times in 1,899 Posts
    Blog Entries
    24
    Rep Power
    833

    Re: SIMS forcing upgrade from SQL 2000 to 2005, Advice needed

    Ah, that makes sense then... Was wondering, as not many schools down here break free from the SCC and go it alone!

  9. #9
    ChrisH's Avatar
    Join Date
    Jun 2005
    Location
    East Lancs
    Posts
    5,009
    Thank Post
    120
    Thanked 282 Times in 260 Posts
    Rep Power
    108

    Re: SIMS forcing upgrade from SQL 2000 to 2005, Advice needed

    650 is steep for the licence. I believe ours was 425 per CPU.

  10. #10
    Grommit's Avatar
    Join Date
    Sep 2006
    Location
    Weston-super-Mare
    Posts
    1,335
    Thank Post
    31
    Thanked 54 Times in 31 Posts
    Rep Power
    25

    Re: SIMS forcing upgrade from SQL 2000 to 2005, Advice needed

    Quote Originally Posted by ChrisH
    650 is steep for the licence. I believe ours was 425 per CPU.
    i went to Ramesys and they are charging

    Microsoft SQL Server 2005 Standard Edition 1 Processor Licence PRICE: £789.00 Qty:

    Where did you get yours for £425 ?

  11. #11
    ChrisH's Avatar
    Join Date
    Jun 2005
    Location
    East Lancs
    Posts
    5,009
    Thank Post
    120
    Thanked 282 Times in 260 Posts
    Rep Power
    108

    Re: SIMS forcing upgrade from SQL 2000 to 2005, Advice needed

    Ours was priced by county. They are usually the same as Ramesys and the like though.

  12. #12

    Join Date
    Jun 2007
    Location
    Barnehurst
    Posts
    157
    Thank Post
    3
    Thanked 2 Times in 2 Posts
    Rep Power
    15

    Re: SIMS forcing upgrade from SQL 2000 to 2005, Advice needed

    err can we get away with SQL 2005 express?

  13. #13

    tech_guy's Avatar
    Join Date
    May 2007
    Location
    That little bit in the middle of Little Old England
    Posts
    8,136
    Thank Post
    1,913
    Thanked 1,345 Times in 743 Posts
    Blog Entries
    3
    Rep Power
    395

    Re: SIMS forcing upgrade from SQL 2000 to 2005, Advice needed

    Yes you can according to all the bumf from Capita.

SHARE:
+ Post New Thread

Similar Threads

  1. Sims SQL 2005 upgrade on a new server?
    By zag in forum MIS Systems
    Replies: 11
    Last Post: 21st November 2007, 08:46 AM
  2. Advice needed please
    By Raja in forum Windows
    Replies: 5
    Last Post: 15th October 2007, 12:15 PM
  3. Server Upgrade Advice Needed
    By Grommit in forum Windows
    Replies: 2
    Last Post: 25th July 2007, 04:01 PM
  4. Advice needed
    By richard in forum General Chat
    Replies: 23
    Last Post: 31st May 2006, 05:10 PM
  5. advice needed on weather a new server is needed
    By projector1 in forum Hardware
    Replies: 3
    Last Post: 24th February 2006, 09: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
  •