+ Post New Thread
Results 1 to 9 of 9
MIS Systems Thread, SIMS SQL 2008 Migration in Technical; Does anyone have a step by step guide for installing full SQL for a sims migration? what accounts need setup ...
  1. #1
    Nik
    Nik is offline

    Join Date
    Jul 2009
    Location
    Cumbria
    Posts
    5
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Question SIMS SQL 2008 Migration

    Does anyone have a step by step guide for installing full SQL for a sims migration? what accounts need setup etc?

    i have been looking at doing this migration and was wondering if i should be installing a new instance of 2008 on the same server as the 2005 instance or whether i should run the upgrade option on the SQL 2008 install? I plan to use the migration tool but wish to have Full SQL rather than the capita provided SQL

    can anyone point me in the right direction? i am using server 2008r2

    thanks

    Nik

  2. #2

    Join Date
    Feb 2009
    Location
    Gloucestershire
    Posts
    14
    Thank Post
    1
    Thanked 2 Times in 2 Posts
    Rep Power
    11
    Hi

    I found a post today on Supportnet from an LA, very comprehensive.

    I can't post the link until i have made this post!

    Thanks

  3. #3

    Join Date
    Feb 2009
    Location
    Gloucestershire
    Posts
    14
    Thank Post
    1
    Thanked 2 Times in 2 Posts
    Rep Power
    11

  4. #4

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,589
    Thank Post
    638
    Thanked 1,305 Times in 1,088 Posts
    Rep Power
    336
    There is a standard document from Capita, and also on a discussion thread on SupportNet there was a detailed explanation of all the tick boxes that need checking on install. It's different to the Express edition on the instructions.

    When you say server 2008 R2, are you referring to Windows Server (supported) or SQL Server (supported from Spring release, mid march)?

    Usually, the easier way to do it is to install a second instance on the original server, as the migration is easier this way. You can disable the old instance once happy all works, and users are ok. Check some of the other threads on here and allow plenty of time. Take backups etc.

  5. #5
    Nik
    Nik is offline

    Join Date
    Jul 2009
    Location
    Cumbria
    Posts
    5
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0
    VJ-09 thanks for the link,

    Vik, yea i mean Windows Server 2008 R2 Not SQL R2

    I have installed and seviced packed SQL 2008 to SP1 and have used the sims migration utility.

    SIMS runs fine on the server however it doesnt work on the desktop machines, fails with reason 0

    i have checked the connect.ini and it is pointing to the correct database?

    any ideas?

  6. #6
    Nik
    Nik is offline

    Join Date
    Jul 2009
    Location
    Cumbria
    Posts
    5
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Managed to fix that, the SQL browser service hadnt started correctly.

    Just trying to redirect the learning gateway, anyone done this before?

  7. #7
    Nik
    Nik is offline

    Join Date
    Jul 2009
    Location
    Cumbria
    Posts
    5
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0
    found out how to do the redirect however even as an administrator of SLG i do not have the correct permissions so i will have to contact capita

  8. #8
    superfletch's Avatar
    Join Date
    Nov 2007
    Location
    South
    Posts
    432
    Thank Post
    145
    Thanked 77 Times in 61 Posts
    Rep Power
    30
    Surely it was a bit late for this?

    How did you manage to run your Census without already upgrading to SQL 2008?

    My colleague wrote the documents on the slatash dot net filepantry - without looking at them I can tell you they will be very comprehensive indeed.
    Last edited by superfletch; 13th February 2011 at 10:02 PM.

  9. #9
    Nik
    Nik is offline

    Join Date
    Jul 2009
    Location
    Cumbria
    Posts
    5
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Apparently although capita dont support SQL 2005 anymore it does still work, but it wont work after the spring release so i am told.

    The documentation is very good and has helped a great deal.

    Just the SLG to sort but that has to be a capita made change.

    Thanks

    Nik

  10. Thanks to Nik from:

    superfletch (13th February 2011)

SHARE:
+ Post New Thread

Similar Threads

  1. SIMS slow after migration to SQL 2008
    By teejay in forum MIS Systems
    Replies: 7
    Last Post: 21st November 2010, 07:50 PM
  2. [SIMS] SIMS SQL 2005 --> 2008 migration
    By cookie_monster in forum MIS Systems
    Replies: 7
    Last Post: 29th July 2010, 02:24 PM
  3. Who's doing their SQL 2008 Migration for SIMS today?
    By chazzy2501 in forum General Chat
    Replies: 4
    Last Post: 30th April 2010, 11:31 AM
  4. SIMS SQL 2008 migration utility
    By Oops_my_bad in forum MIS Systems
    Replies: 28
    Last Post: 11th February 2010, 02:29 PM
  5. SIMS SQL 2008 migration
    By matt40k in forum MIS Systems
    Replies: 0
    Last Post: 8th August 2009, 12:08 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
  •