+ 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,909
    Thank Post
    954
    Thanked 451 Times in 380 Posts
    Blog Entries
    12
    Rep Power
    93

    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
    18,157
    Thank Post
    522
    Thanked 2,552 Times in 1,981 Posts
    Blog Entries
    24
    Rep Power
    877

    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,490
    Thank Post
    282
    Thanked 196 Times in 167 Posts
    Rep Power
    76

    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,909
    Thank Post
    954
    Thanked 451 Times in 380 Posts
    Blog Entries
    12
    Rep Power
    93

    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
    17

    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
    19

    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,484
    Thank Post
    10
    Thanked 502 Times in 442 Posts
    Rep Power
    114

    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,909
    Thank Post
    954
    Thanked 451 Times in 380 Posts
    Blog Entries
    12
    Rep Power
    93

    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
    17

    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
  •