+ Post New Thread
Results 1 to 9 of 9
MIS Systems Thread, August update + SQL change compulsary? in Technical; Just about to do the update, do I need to do the SQL change over at the same time?...
  1. #1
    zag
    zag is offline
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    3,762
    Thank Post
    897
    Thanked 416 Times in 350 Posts
    Blog Entries
    12
    Rep Power
    86

    August update + SQL change compulsary?

    Just about to do the update, do I need to do the SQL change over at the same time?

  2. #2

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,652
    Thank Post
    516
    Thanked 2,443 Times in 1,891 Posts
    Blog Entries
    24
    Rep Power
    831

    Re: August update + SQL change compulsary?

    The SQL change is required before the November release. The august/september releases don't need it.

  3. #3
    enjay's Avatar
    Join Date
    Apr 2007
    Location
    Reading, Berkshire, UK
    Posts
    4,485
    Thank Post
    282
    Thanked 196 Times in 167 Posts
    Rep Power
    75

    Re: August update + SQL change compulsary?

    Nope, but you will need to have done the SQL migration before you apply the November update.

  4. #4
    zag
    zag is offline
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    3,762
    Thank Post
    897
    Thanked 416 Times in 350 Posts
    Blog Entries
    12
    Rep Power
    86

    Re: August update + SQL change compulsary?

    Yeh great, just did the Aug update and no problems, Seems the September update is just a DVD disk of the Aug update, it contains nothing extra.

    Push the SQL change under the rug for a few more weeks then

  5. #5

    Join Date
    May 2007
    Location
    Hale Barns
    Posts
    211
    Thank Post
    39
    Thanked 8 Times in 2 Posts
    Rep Power
    16

    Re: August update + SQL change compulsary?

    Anyone had the cast iron unmentionables to do the SQL migration yet. I think everything is in place (just a few issues with RMs Portal PLus to sort out first).....I just don't want to break SIMS.

    Anyone have an idea how long it will take?

    Thanks

    Nick

  6. #6

    Join Date
    May 2006
    Posts
    159
    Thank Post
    5
    Thanked 10 Times in 5 Posts
    Rep Power
    18

    Re: August update + SQL change compulsary?

    I Installed SQL2005 on the server, alongside SQL2000. All seemed to go well.
    until users logged into SIMS for the first time, and logged out.

    SIMS seemed unable to locate the correct SQL instance, even though no DB was detached or migrated. I ended up having to remove SQL2005 to get SIMS working again.

    Not looking forward to the November update!

  7. #7
    DMcCoy's Avatar
    Join Date
    Oct 2005
    Location
    Isle of Wight
    Posts
    3,432
    Thank Post
    10
    Thanked 488 Times in 428 Posts
    Rep Power
    111

    Re: August update + SQL change compulsary?

    I've done SQL2005 and FMS migration so far, all seems to be working (as much as it ever does).

    Did you change the connect.ini klawd? The instructions are quite good. I also had to remove some lines from my connect.ini on the clients too though.

  8. #8
    zag
    zag is offline
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    3,762
    Thank Post
    897
    Thanked 416 Times in 350 Posts
    Blog Entries
    12
    Rep Power
    86

    Re: August update + SQL change compulsary?

    Where are the instructions? I check capita's site but there are about 10 different hot topics on the migration!

    Also did you need the SA password?

  9. #9

    Join Date
    May 2007
    Location
    Hale Barns
    Posts
    211
    Thank Post
    39
    Thanked 8 Times in 2 Posts
    Rep Power
    16

    Re: August update + SQL change compulsary?

    The file on Supportnet SIMSSQL2005Migration_12873.pdf is pretty helpful and straightforward (for a change). I came unstuck when our server wasn't on SP1 at least...which took an extra hour.

    Also when it prompted for the db to migrate, the list was empty, a solution for which was posted on here in my thread "SIMS SQL Help Needed" or something similar

    ...the guide doesn't tell you about this "feature"

SHARE:
+ Post New Thread

Similar Threads

  1. Microsoft Debuts Update Update Suite
    By mattx in forum General Chat
    Replies: 4
    Last Post: 1st November 2007, 04:07 PM
  2. Sims August Update and Permissions
    By Jamie_a in forum MIS Systems
    Replies: 1
    Last Post: 2nd October 2007, 11:06 AM
  3. SIMS August Update
    By wesleyw in forum MIS Systems
    Replies: 6
    Last Post: 22nd September 2007, 10:18 PM
  4. sims august update problems
    By Jonny_sims in forum MIS Systems
    Replies: 2
    Last Post: 12th September 2007, 03:56 PM
  5. August Update Without SQL
    By enjay in forum MIS Systems
    Replies: 10
    Last Post: 31st August 2007, 12:58 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
  •