+ Post New Thread
Results 1 to 11 of 11
MIS Systems Thread, SQL 2012 Migration Planning Advice - Posted on SupportNet in Technical; For info, Capita have posted two documents on SupportNet around the SQL 2012 migration. It makes interesting reading. Resource ID's ...
  1. #1
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 490 Times in 375 Posts
    Rep Power
    0

    SQL 2012 Migration Planning Advice - Posted on SupportNet

    For info, Capita have posted two documents on SupportNet around the SQL 2012 migration. It makes interesting reading. Resource ID's in the quote below:

    SQL 2012 MIgration Planning Advice

    I have posted two documents to assist with planning and implementing the SQL 2012 migration that I would strongly recommend that anyone planning to migrate to SQL2012 should read.

    The first is called 'SQL Migration Planning Guide' (resource id: 21113) and it details our recommended timescales for implementing the SQL migration dependent on the software installed at a site.

    The second is called 'SQL 2012 Migration Frequently Asked Questions' (resource id: 21101) and it provides additional advice and information to support you with the SQL2012 migrations.

    Regards,

    Jon
    Annoyingly, seems SOLUS3 is going to be a separate migration from the SIMS, FMS and Discover tools:

    Q. I need more information on the SQL 2012 migration with SOLUS 3

    A. We have kept the SQL 2012 migration of the SOLUS 3 system outside of the SQL 2012 Migration tool in order to maintain security and we will be releasing the SOLUS 3.6 update in order to support the migration. SOLUS 3.6 will fully support SQL 2012 and it will contain functionality that enables you to migrate your SOLUS 3 system to a new server and enables the SOLUS 3.6 agents to redirect to the new server with minimal intervention. The SOLUS 3.6 release is not part of the SIMS 2013 Summer Release and is anticipated to be made available in August 2013.
    Last edited by Rawns; 13th June 2013 at 12:52 PM.

  2. 2 Thanks to Rawns:

    vikpaw (16th June 2013), zag (17th June 2013)

  3. #2

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,970
    Thank Post
    673
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    This might be useful for the inevitable questions that will crop up later

    PLEASE NOTE THIS REFERS TO AUTOMATIC MIGRATION AVAILABILITY - NOT SUPPORT DATES.
    You can migrate manually earlier.

    These timeframes are outlined in the diagram below.


    Product SIMS Release
    Summer 2013 Autumn 2013 Spring 2014
    SIMS X
    FMS X
    SOLUS3.6 X*
    Discover X
    SLG X*
    InTouch X

    X Migration Automated
    X* Migration process provided outside of the SQL Migration Utility

    The above table outlines the recommended approach to migrating to SQL2012, however, as stated above, if you want to migrate sooner than is recommended please read the FAQ sheet on SupportNet (resource ID: 21101) for more details on how you could do this.
    Last edited by vikpaw; 17th June 2013 at 09:22 AM. Reason: Correct coding issues

  4. 2 Thanks to vikpaw:

    Rawns (17th June 2013), zag (17th June 2013)

  5. #3
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 490 Times in 375 Posts
    Rep Power
    0
    It's going to be fun for sites with a mixture of the above packages! eg, all of them!

  6. #4
    superfletch's Avatar
    Join Date
    Nov 2007
    Location
    South
    Posts
    434
    Thank Post
    146
    Thanked 77 Times in 61 Posts
    Rep Power
    31
    While I'm sure the information given in vikpaw post is the correct information (as I've read that article and it is the one aimed specifically at SQL Migrations) the Capita Pre-Release note for Summer 2013 says this:

    "This release is fully supported on SQL2012 for SIMS, FMS, Discover, SLG, Solus3.6 and InTouch."

    Basically saying Discover will be supported on SQL 2012 from Summer. I guess this implies it might work at any rate.... ....bit of testing against the Waters Edge Database anyone?

    Capita Documentation 21036

    The left hand and the right hand...
    Last edited by superfletch; 17th June 2013 at 08:50 AM.

  7. #5

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,970
    Thank Post
    673
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    If you use SOLUS 3 or SLG then yes, otherwise just wait for the latest X you can.
    For me, that's summer. :O)

  8. #6

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,970
    Thank Post
    673
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Quote Originally Posted by superfletch View Post
    While I'm sure the information given in @vikpaw post is the correct information the Capita Pre-Release note for Summer 2013 says:

    "This release is fully supported on SQL2012 for SIMS, FMS, Discover, SLG, Solus3.6 and InTouch."

    Discover will be supported on SQL 2012 from Summer??

    Implies it might work at any rate.... ....bit of testing against the Waters Edge Database anyone?

    Capita Documentation 21036
    Support is there, but automatic migration tools are not.

  9. Thanks to vikpaw from:

    superfletch (17th June 2013)

  10. #7
    superfletch's Avatar
    Join Date
    Nov 2007
    Location
    South
    Posts
    434
    Thank Post
    146
    Thanked 77 Times in 61 Posts
    Rep Power
    31
    Quote Originally Posted by vikpaw View Post
    If you use SOLUS 3 or SLG then yes, otherwise just wait for the latest X you can.
    For me, that's summer. :O)
    Thank you - I understand now.

  11. #8
    jbutlin's Avatar
    Join Date
    Oct 2011
    Location
    Northampton
    Posts
    35
    Thank Post
    11
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    How have people handled the mix of Solus 3 and SQL 2012 so far? All our schools are currently running SQL 2008 - would it be better to upgrade them all to SQL 2012 first and then install Solus 3 afterwards? Just wondering how other support units have done it.

    Any advice would be appreciated!

    thanks

  12. #9
    Ghostgame's Avatar
    Join Date
    Jun 2012
    Location
    Ipswich
    Posts
    281
    Thank Post
    30
    Thanked 66 Times in 39 Posts
    Rep Power
    20
    If you have not installed S3 already I would wait until after you have done the migration.
    It just means you then don't have to change all the settings afterwards and then use the tool in S3 to migrate the S3 database as well.

  13. 2 Thanks to Ghostgame:

    jbutlin (24th September 2013)

  14. #10
    jbutlin's Avatar
    Join Date
    Oct 2011
    Location
    Northampton
    Posts
    35
    Thank Post
    11
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Thanks a lot, that is what I suspected but wasn't sure!

    cheers

  15. #11
    jbutlin's Avatar
    Join Date
    Oct 2011
    Location
    Northampton
    Posts
    35
    Thank Post
    11
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    anyone taken the plunge and migrated yet? How does the redirection service work?

    I will stop hijacking this thread with annoying questions now.

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] Migrated to SQL 2012 - Tons of password resets!
    By adamf in forum MIS Systems
    Replies: 12
    Last Post: 17th February 2014, 06:00 PM
  2. looking for a recent post on these forums...
    By beeswax in forum Other Stuff
    Replies: 3
    Last Post: 25th March 2007, 08:36 AM
  3. Advice, pointers on Blogs and blog casts.
    By Kyle in forum How do you do....it?
    Replies: 13
    Last Post: 23rd April 2006, 08:54 PM
  4. advice needed on weather a new server is needed
    By projector1 in forum Hardware
    Replies: 3
    Last Post: 24th February 2006, 09:20 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
  •