+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 22
MIS Systems Thread, Backup SIMS database from SQL Server 2005 to SQL Server 2008 R2 in Technical; What happens in case you need to move from SQL Server 2005 to 2008 R2 for SIMS? Is it just ...
  1. #1

    Join Date
    Feb 2008
    Location
    Portsmouth
    Posts
    163
    Thank Post
    16
    Thanked 18 Times in 13 Posts
    Rep Power
    17

    Backup SIMS database from SQL Server 2005 to SQL Server 2008 R2

    What happens in case you need to move from SQL Server 2005 to 2008 R2 for SIMS?

    Is it just a matter of backing up and restoring the databases to 2008 R2?



    Any help would be really appreciated.

  2. #2

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    3,217
    Thank Post
    394
    Thanked 406 Times in 328 Posts
    Blog Entries
    8
    Rep Power
    182
    The database needs to have gone through the conversion process to ensure it works properly. I have not tried simply moving from one to another, even if it works from the start you won't know what else might not be working right later on.

  3. Thanks to GREED from:

    dtakias (10th January 2011)

  4. #3

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    18,343
    Thank Post
    525
    Thanked 2,597 Times in 2,015 Posts
    Blog Entries
    24
    Rep Power
    888
    Also take into account that SQL Server 2008 R2 is not yet supported according to the Capita system requirements document.

  5. Thanks to localzuk from:

    dtakias (10th January 2011)

  6. #4

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    3,217
    Thank Post
    394
    Thanked 406 Times in 328 Posts
    Blog Entries
    8
    Rep Power
    182
    Quote Originally Posted by localzuk View Post
    Also take into account that SQL Server 2008 R2 is not yet supported according to the Capita system requirements document.
    errr.. yer... that to... most importantly!!!

  7. #5

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,887
    Thank Post
    749
    Thanked 1,466 Times in 1,218 Posts
    Rep Power
    364
    Contact your support team or search on Capitas SupportNet (or threads here for that matter). You need to do the SQL 2008 migration using the Capita Tool. It's not a trivial backup and restore database process.
    The deadline for this was October, there should have been some documentation / notifications sent your way.

  8. Thanks to vikpaw from:

    dtakias (10th January 2011)

  9. #6

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,480
    Thank Post
    372
    Thanked 657 Times in 537 Posts
    Rep Power
    162
    Could pretty much do it and it'll work, but you'll hit problems later if you just backup\restore.

  10. #7
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    55
    The following is part of an extract from an email received to day re. UAT for Spring Release:-

    The spring release will include new functionality and changes within the following areas;
    ........ SQL Server 2008 R2 support.

    That doesn't mean it will definitely appear in Spring - it may get broken by the testers.
    Mind you - I know of one school, to remain nameless, that has used it since Feb 2009 with no problems! So it will hopefully be ok!

  11. Thanks to Sivadam from:

    dtakias (10th January 2011)

  12. #8

    Join Date
    Feb 2008
    Location
    Portsmouth
    Posts
    163
    Thank Post
    16
    Thanked 18 Times in 13 Posts
    Rep Power
    17
    Thanks guys, I've just seen the latest requirements and 2008 R2 is not listed. Basically the person who was in charge missed the deadline so we now need to migrate as soon as possible.

    Our local authority will charge for this, so ideally we need to do it ourselves. I've been looking into other threads but I cannot find a link for the Capita tool.

    Has anyone got a link for this?

  13. #9

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,887
    Thank Post
    749
    Thanked 1,466 Times in 1,218 Posts
    Rep Power
    364
    go to solus and download simsinfrastructure updates. then run simsinfrastructure.exe or some such file and then it will create the simssql2008 upgrade .exe file, and the fms one. sorry i've probably got the names wrong but the instruction manual from Capita lays it all out. The file is also on a thread here too i think, certainly the process of how to 'unpack' the tool is somewhere.
    sorry can't link to it, on a limited connection at the mo'.

  14. Thanks to vikpaw from:

    dtakias (10th January 2011)

  15. #10
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    55
    Quote Originally Posted by dtakias View Post
    Thanks guys, I've just seen the latest requirements and 2008 R2 is not listed..............
    KB100597 - Does Capita support SQL Server 2008 R2?

    Confirmation of support for this from Spring 2011!

  16. #11

    Join Date
    Feb 2008
    Location
    Portsmouth
    Posts
    163
    Thank Post
    16
    Thanked 18 Times in 13 Posts
    Rep Power
    17
    Quote Originally Posted by vikpaw View Post
    go to solus and download simsinfrastructure updates. then run simsinfrastructure.exe or some such file and then it will create the simssql2008 upgrade .exe file, and the fms one. sorry i've probably got the names wrong but the instruction manual from Capita lays it all out. The file is also on a thread here too i think, certainly the process of how to 'unpack' the tool is somewhere.
    sorry can't link to it, on a limited connection at the mo'.
    Thanks, will have a go. Where do I get the latest version of the instruction manual?


    Quote Originally Posted by Sivadam View Post
    KB100597 - Does Capita support SQL Server 2008 R2?

    Confirmation of support for this from Spring 2011!
    That's good news. In that case do we stick with 2008 and upgrade to R2 in a few months?

  17. #12

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,887
    Thank Post
    749
    Thanked 1,466 Times in 1,218 Posts
    Rep Power
    364
    Get the latest manual from Capita's SupportNet website.
    You need to migrate to 2008 as soon as possible otherwise you wont be supported.
    Once that's done you can move to R2 at a later date, but it's not compulsory so there's no hurry.

  18. #13

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,887
    Thank Post
    749
    Thanked 1,466 Times in 1,218 Posts
    Rep Power
    364
    i just checked and if you download the autumn infrastructure updates and then run the SIMSSQLInfrastructureSetup.exe it will unpack the migration tool along with the latest documentation.

    You could also search for documentation from the home page. search terms sql 2008 will give a link to resource 16101 which is the sims mini guide.

  19. #14

    Join Date
    Feb 2008
    Location
    Portsmouth
    Posts
    163
    Thank Post
    16
    Thanked 18 Times in 13 Posts
    Rep Power
    17
    Quote Originally Posted by vikpaw View Post
    i just checked and if you download the autumn infrastructure updates and then run the SIMSSQLInfrastructureSetup.exe it will unpack the migration tool along with the latest documentation.

    You could also search for documentation from the home page. search terms sql 2008 will give a link to resource 16101 which is the sims mini guide.
    Many Thanks. I found the pdf file!
    Since I am a still newbie when comes to SIMS, can I just confirm something. Do I use SOLUS to download the autumn infrastructure update? Will SIMSSQLInfrastructureSetup.exe be included in the update?

  20. #15

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,887
    Thank Post
    749
    Thanked 1,466 Times in 1,218 Posts
    Rep Power
    364
    yes that's right. just be careful that if you are not on the latest version that you dont inadvertently also download a SIMS update and install it.
    there is a check box you can click to make sure any downloaded update is not applied yet.



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

Similar Threads

  1. [SIMS] SIMS SQL 2005 --> 2008 migration
    By cookie_monster in forum MIS Systems
    Replies: 7
    Last Post: 29th July 2010, 03:24 PM
  2. Moving from SQL Server 2005 to 2008
    By speckytecky in forum MIS Systems
    Replies: 19
    Last Post: 9th July 2009, 04:34 PM
  3. SIMS SQL Server 2005 re-install
    By philserre in forum MIS Systems
    Replies: 6
    Last Post: 14th October 2008, 09:44 PM
  4. sims.net sql server 2005
    By itgeek in forum MIS Systems
    Replies: 2
    Last Post: 14th March 2008, 07:02 PM
  5. Sims SQL 2005 upgrade on a new server?
    By zag in forum MIS Systems
    Replies: 11
    Last Post: 21st November 2007, 09:46 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
  •