+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 29
MIS Systems Thread, SIMS SQL 2008 migration utility in Technical; B*gger. Come to do our SIMS migration to 2008 today and just realised I need a seperate utility for the ...
  1. #1
    Oops_my_bad's Avatar
    Join Date
    Jan 2007
    Location
    Man chest hair
    Posts
    1,738
    Thank Post
    438
    Thanked 53 Times in 50 Posts
    Rep Power
    30

    Angry SIMS SQL 2008 migration utility

    B*gger.

    Come to do our SIMS migration to 2008 today and just realised I need a seperate utility for the migration - SIMSSQLInfrastructuresetup.exe

    Can this be downloaded from anywhere or, dare I say it, anyone willing to provide a link?

    Capita not in until tomorrow...

    TIA
    Last edited by Oops_my_bad; 22nd November 2009 at 04:00 PM.

  2. #2
    speckytecky's Avatar
    Join Date
    May 2006
    Location
    UK
    Posts
    2,531
    Thank Post
    3,415
    Thanked 261 Times in 213 Posts
    Blog Entries
    3
    Rep Power
    110
    Not done any SQL work before but my Busines Manager asked if I would do the SIMS Migration from SQL 2005 to SQL 2008 on her SIMS server - and presumably on the other Ofice machines running SIMS when the time is due. Any advice on this please?

  3. #3
    Oops_my_bad's Avatar
    Join Date
    Jan 2007
    Location
    Man chest hair
    Posts
    1,738
    Thank Post
    438
    Thanked 53 Times in 50 Posts
    Rep Power
    30
    Quote Originally Posted by speckytecky View Post
    Not done any SQL work before but my Busines Manager asked if I would do the SIMS Migration from SQL 2005 to SQL 2008 on her SIMS server - and presumably on the other Ofice machines running SIMS when the time is due. Any advice on this please?
    Sure thing.. I've attached the migration mini guide that capita provide, it's pretty straight forward

    Personally, I'm doing it this way:

    1) Install new SQL2008 instance on existing server (you can either use Capita installer tool or install your own)
    2) Upgrade existing SIMS to November 09 release (await completion of Autumn census first!) + Upgrade FMS to latest version
    3) Backup, backup, backup
    4) Move SIMS & FMS databases from SQL2005 to SQL2008 instance when ready using capita tool
    5) reconfigure sims files, Docserv, SLG2 etc
    6) another backup
    7) Shutdown SQL 2005 instance (if nothing else is on there) and leave for a few months before removing, just incase.
    8) deploy SOLUS3

    After that I'll be migrating the lot to a nice fresh VM
    Attached Files Attached Files

  4. Thanks to Oops_my_bad from:

    speckytecky (23rd November 2009)

  5. #4

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,433
    Thank Post
    368
    Thanked 646 Times in 528 Posts
    Rep Power
    159
    Quote Originally Posted by Oops_my_bad View Post
    Sure thing.. I've attached the migration mini guide that capita provide, it's pretty straight forward

    Personally, I'm doing it this way:

    1) Install new SQL2008 instance on existing server (you can either use Capita installer tool or install your own)
    2) Upgrade existing SIMS to November 09 release (await completion of Autumn census first!) + Upgrade FMS to latest version
    3) Backup, backup, backup
    4) Move SIMS & FMS databases from SQL2005 to SQL2008 instance when ready using capita tool
    5) reconfigure sims files, Docserv, SLG2 etc
    6) another backup
    7) Shutdown SQL 2005 instance (if nothing else is on there) and leave for a few months before removing, just incase.
    8) deploy SOLUS3

    After that I'll be migrating the lot to a nice fresh VM

    5 is done with the utility.
    8 is optional, and I would wait for a bit before you do it, also you might want to do it before moving to SQL 2008 to deploy the Autumn release to the clients, unless you're doing all this in one day.

    Have PM you linky to files -it's also on supportnet

  6. 4 Thanks to matt40k:

    Oops_my_bad (22nd November 2009), Origin (18th March 2010), speckytecky (23rd November 2009), zag (23rd November 2009)

  7. #5
    Oops_my_bad's Avatar
    Join Date
    Jan 2007
    Location
    Man chest hair
    Posts
    1,738
    Thank Post
    438
    Thanked 53 Times in 50 Posts
    Rep Power
    30
    Thanks, all done

  8. #6

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,639
    Thank Post
    683
    Thanked 1,400 Times in 1,160 Posts
    Rep Power
    353
    Quote Originally Posted by Oops_my_bad View Post
    Thanks, all done
    sweet. any issues to share or tips...?

  9. #7
    speckytecky's Avatar
    Join Date
    May 2006
    Location
    UK
    Posts
    2,531
    Thank Post
    3,415
    Thanked 261 Times in 213 Posts
    Blog Entries
    3
    Rep Power
    110
    Thanks oops My Bad and Matt40K,

    Couple of remaining questions:

    1. Any timescale that this needs to be done by.

    2. Am I right in thinking it's just the SIMS server and not clients that this needs to be done on.

  10. #8

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,639
    Thank Post
    683
    Thanked 1,400 Times in 1,160 Posts
    Rep Power
    353
    I think we have over a year, and it only needs doing to the server. The clients wont be affected.

  11. Thanks to vikpaw from:

    speckytecky (23rd November 2009)

  12. #9

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,639
    Thank Post
    683
    Thanked 1,400 Times in 1,160 Posts
    Rep Power
    353
    Actually just under a year. From Capita FAQs:

    SIMS will be supported on the SQL2008 family of database servers from October 2009 and
    support for SIMS on the SQL2005 family of servers is scheduled to be phased out by
    October 2010.
    SIMS will provide an Installation routine to Install and configure a SQL Express 2008
    installation suitable to host a SIMS database in this timeframe.
    Customers, who already have or plan to deploy SQL2008 in advance to host SIMS, should
    configure that server such that it is suitable to host a SIMS database.

  13. #10
    Oops_my_bad's Avatar
    Join Date
    Jan 2007
    Location
    Man chest hair
    Posts
    1,738
    Thank Post
    438
    Thanked 53 Times in 50 Posts
    Rep Power
    30
    Quote Originally Posted by vikpaw View Post
    sweet. any issues to share or tips...?
    Yes..make sure you have everything you need before starting..

  14. #11

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,433
    Thank Post
    368
    Thanked 646 Times in 528 Posts
    Rep Power
    159
    Quote Originally Posted by jinnantonnix View Post
    If you follow best practices, and keep your data files and log files on separate partitions

    Anymore info on this? Just seems to add more hassle for no real benefit.

  15. #12
    Oops_my_bad's Avatar
    Join Date
    Jan 2007
    Location
    Man chest hair
    Posts
    1,738
    Thank Post
    438
    Thanked 53 Times in 50 Posts
    Rep Power
    30
    Is this all the migration utility does then? Detaches it from the old SQL instance to your new one?

  16. #13

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,433
    Thank Post
    368
    Thanked 646 Times in 528 Posts
    Rep Power
    159
    It does a bit more then just that...

  17. #14

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,433
    Thank Post
    368
    Thanked 646 Times in 528 Posts
    Rep Power
    159
    Also changes the log file format as well. No longer transactional backups.

  18. Thanks to matt40k from:

    speckytecky (26th November 2009)

  19. #15

    Join Date
    Apr 2009
    Posts
    4
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Any info could help.

    Done the SQL migration onto a new machine and all is working ok apart fron the document server. I have remapped and setup in sims. When I import reports they import into sims\documents and not Docstorage on the root of the drive as I have set it up. The result of this is that no reports will now run.

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. [SIMS] SIMS Tidy Backups - SQL 2008 - Autumn release
    By matt40k in forum MIS Systems
    Replies: 49
    Last Post: 11th February 2011, 01:12 PM
  2. Migrate SIMS database to SQL 2008
    By speckytecky in forum MIS Systems
    Replies: 8
    Last Post: 10th October 2009, 09:43 AM
  3. SIMS SQL 2008 migration
    By matt40k in forum MIS Systems
    Replies: 0
    Last Post: 8th August 2009, 12:08 AM
  4. Ease of SIMS migration to SQL 2005
    By Ric_ in forum MIS Systems
    Replies: 12
    Last Post: 29th February 2008, 02:06 PM
  5. SIMs backup script after SQL 2005 migration failing...
    By mullet_man in forum MIS Systems
    Replies: 13
    Last Post: 23rd November 2007, 06:03 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
  •