+ Post New Thread
Results 1 to 11 of 11
MIS Systems Thread, sims sql upgrade question in Technical; Hi all have trolled through some posts on here but am still not sure (and given that i can't get ...
  1. #1

    Join Date
    Oct 2006
    Location
    uk
    Posts
    494
    Thank Post
    19
    Thanked 3 Times in 2 Posts
    Rep Power
    16

    sims sql upgrade question

    Hi all have trolled through some posts on here but am still not sure (and given that i can't get through to the support desk) will ask the question here.

    I currently run full MS SQL server 2000 (not msde) do i need to upgrade this to full SQL server 2005 to be able run the latest sims releases or is it only those still running msde that need to upgrade?

    as always thanks in advance.

  2. #2
    Vegas's Avatar
    Join Date
    Jul 2005
    Location
    Gloucestershire
    Posts
    371
    Thank Post
    19
    Thanked 38 Times in 31 Posts
    Rep Power
    30

    Re: sims sql upgrade question

    Before you can run the November upgrade you will need to have upgraded to SQL2005

  3. #3

    Join Date
    Oct 2006
    Location
    uk
    Posts
    494
    Thank Post
    19
    Thanked 3 Times in 2 Posts
    Rep Power
    16

    Re: sims sql upgrade question

    full ?

  4. #4
    Vegas's Avatar
    Join Date
    Jul 2005
    Location
    Gloucestershire
    Posts
    371
    Thank Post
    19
    Thanked 38 Times in 31 Posts
    Rep Power
    30

    Re: sims sql upgrade question

    Yep

  5. #5

    Join Date
    Mar 2006
    Location
    Yorkshire
    Posts
    5
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: sims sql upgrade question

    Hi, i think if you have full sql 2000 you must upgrade to full 2005 before the November release. Also might be worth noting you should have service pack 3 or above on sql 2000 before running sims upgrade utility.

    Hope this helps.

  6. #6

    Join Date
    Oct 2006
    Location
    uk
    Posts
    494
    Thank Post
    19
    Thanked 3 Times in 2 Posts
    Rep Power
    16

    Re: sims sql upgrade question

    is it a traight upgrade path then? ie pop in 2005 and it does it itself or is there a almighty migration process (i worry to death whenever theres any major change to sims, why is that i wonder??)

  7. #7
    woody's Avatar
    Join Date
    Jun 2005
    Location
    Carlisle, Cumbria
    Posts
    613
    Thank Post
    3
    Thanked 17 Times in 15 Posts
    Rep Power
    22

    Re: sims sql upgrade question

    I think the best way forward is to install SQL2005 in tandem with SQL2000. When you install 2005, it will ask if you want it to automatically upgrade all your 2000 DBs to 2005. Say NO!

    After it is installed, ask your local helpdesk to make the migration tool available to you via solus. Do your backups one final time, then run the Migration!

  8. #8

    Join Date
    Oct 2006
    Location
    uk
    Posts
    494
    Thank Post
    19
    Thanked 3 Times in 2 Posts
    Rep Power
    16

    Re: sims sql upgrade question

    cheers mate will do

  9. #9

    Join Date
    Dec 2007
    Posts
    149
    Thank Post
    0
    Thanked 5 Times in 5 Posts
    Rep Power
    16

    FMS Upgrade

    Will the FMS upgrade run on a database on the same sql server 2005 server? Our instructions are that we MUST install SQL Express on the SIMS Server as well as the sql 2005!

    ChrisJ

  10. #10
    sahmeepee's Avatar
    Join Date
    Oct 2005
    Location
    Greater Manchester
    Posts
    795
    Thank Post
    20
    Thanked 70 Times in 42 Posts
    Rep Power
    33
    Our SIMS and FMS run on separate servers, each with their own full copy of SQL2005. I'm pretty sure you can run them both on the same SQL2005 install, just with different instances.

    There will almost certainly be information about the supported configurations on SupportNet.

  11. #11

    Join Date
    Feb 2006
    Location
    South Cumbria
    Posts
    199
    Thank Post
    26
    Thanked 29 Times in 24 Posts
    Rep Power
    22
    We're using SIMS and FMS on the same SQL 2005 instance without any problems

SHARE:
+ Post New Thread

Similar Threads

  1. Sims September Upgrade - How long does it take?
    By AnnDroyd in forum MIS Systems
    Replies: 4
    Last Post: 22nd November 2007, 12:26 PM
  2. Sims SQL 2005 upgrade on a new server?
    By zag in forum MIS Systems
    Replies: 11
    Last Post: 21st November 2007, 08:46 AM
  3. SIMS August upgrade.
    By User3204 in forum MIS Systems
    Replies: 1
    Last Post: 20th August 2007, 08:14 PM
  4. Sims upgrade not working on some machines?
    By Kyle in forum MIS Systems
    Replies: 8
    Last Post: 14th June 2007, 01:47 PM
  5. SIMS Workstation upgrade
    By paul in forum MIS Systems
    Replies: 9
    Last Post: 15th May 2007, 01:00 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
  •